Crosstab Query horizontal totals

[Guest]

New user please help....
In the crosstab query I have been able to query each dept's expenses by
month - last COLUMN being an extended total adding each month together by
dept and giving an annual ttl thus far for each dept. I need a horizontal
ROW total...one that would in ADDITION add all dept totals for each month,
rather than all months for each dept (which is in the last COLUMN). I can't
seem to make this happen. I'm wondering if it can only be done under
"Reports" and if so - assistance in doing so in the Report would also help,
or direct me to a source more detailed than the Online Access Training.

EX of what is needed:
Dept ID Jan Feb Mar Apr TTL EXT Cost
2099 10 10 10 30
1110 5 5 5 15
TOTAL 15 15 5 10 45

Thanks so much.
Karin Shepard

 

[Duane Hookom]

You can create a totals row in a report footer. Your control source might be
something like:
=Sum([Jan])

Jeff Conrad has lots of links (including tutorials) at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html.