Moving the position of the total column in a crosstab query

[rtlight]

I have struggled trying to place the Total column in a crosstab query in the rightmost column of the result.

I suspect this will have to be done in either VBA or SQL. Can someone steer me to a method or code example to accomplish this?

[weekend00]

just put the total column in the rightmost in the design view.

[rtlight]

The design view already has the total in the rightmost column but the output places it in the leftmost column.

The design has the following column listings:

var1.............var2...........var3..........Tota l Of var3:var3
group by.......group by.....count........count
row heading..col heading..value row..heading


The output is:

......................Total of var3......... var2 value 1................ var2 value2 etc
Var1 value1
Var1 value2
etc

[weekend00]

in the result sheet, drag the total column to rightmost, save the query. then that's it.

[rtlight]

Thanks for the tip. Do you know why it works?

[weekend00]

Access save the design of your adjustment.