Cross Tab Sub Total

[Natalie]

I have a report that is based on a cross tab query. the column headings in
the query are dates. I have grouped the report by States and region. I
would like to do a subtoal by state and region and also a report total.

How can I set the text box in the group footer to sum each value column?

 

[Duane Hookom]

I would set up the report using the solution found at faq703-5466. You would
need to substitute your date interval for Months.

 

[Natalie]

Where can i find faq703-5466?

I would set up the report using the solution found at faq703-5466. You would
need to substitute your date interval for Months.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm

 

[Duane Hookom]

Sorry, I thought I was posting in another forum where the URL is inserted. Try:
http://www.tek-tips.com/faqs.cfm?fid=5466