Calculating Row and Column Sums in a Crosstab Query

[van_slanzar]

I created a Crosstab Query for records which were split up by Months and
Locations. Locations was the Row Heading and the Months was the column
heading with the Sum of money they collected at each location for each month
as the value being calculated at the intersection. I got the Row Sums for the
Locations but I'm trying to figure out now how to get the Columns Sums for
each month. I tried to flip the Column and Row around making the Months the
Row heading and the locations the column heading and it seemed to work but
when trying to put the two the two crosstabs together in a simple query I get
an error saying it can't link the two queries. Any help would be greatly
appreciated.

 

[Duane Hookom]

Normally you would use the crosstab as the record source for a form or
report where you can display column totals in footer sections.

If that doesn't work save a copy of your first crosstab replacing Locations
as a Row Heading with an expression like:
AllLocations: "All Locations"

Then use a union query to combine the two crosstabs.