How can I total the crosstab columns in a report?

[cynteeuh]

I have a crosstab query I'm using as a report. What's the simplest way to
total the crosstab columns in the rpt footer? I don't know vba.

Thanks in advance for your help!

 

[Allen Browne]

Just add the value field to the crosstab again, again as Row Heading,
choosing Sum in the Total row.

Example here:
http://allenbrowne.com/ser-67.html#RowTotal

 

[cynteeuh]

Thanks, but I already have that info. I'm trying to total all those columns,
including the one which totals all the columns in the row (your example).

e.g.
Tot CA TX WA
Joe 4 1 1 2
Jan 2 1 1
Tess 5 3 1 1
Total 11 4 3 4 (This is the row I'm trying to setup)

Thanks for your help!

 

[Allen Browne]

In the Report Footer section of your report, add a text box with Control
Source of:
=Sum([CA])
and so forth for the other columns.

In Access 2007, you can display the totals at the bottom of the query
itself, but not in earlier versions.