Move Crosstab Total to End

[CCIDBMNG]

I created a crosstab query that I'm using to dynamically create a form. I know how to create a total in a crosstab query but it creates it before it creates the columns. I need the total column to show at the end of the columns. Does anyone know how to do this?

 

[CCIDBMNG]

No matter where I place the total column it always places it before the crosstab columns.

 

[raskew]

Hi -

If your query is open in design view, highlight the totals column, drag it to the end position then save the query!

It's been my experience that this process will stick the totals column where you place it. Saving the query, while in design view, seems to be the key.

Bob

 

[CCIDBMNG]

That works fine when viewing the query but i need it to display at the end in the dynamic form I am creating. I will have to use code like Pat suggested.