How can I total the crosstab columns in a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
 
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.
 
Back
Top