Totals in a report

C

chris

I have a report grouped first on School Name, then on Company

In the Company footer, I have totals for items from each Company

In the School Name footer, I have one total for all of the companies totals
combined.

At the end of the report, I have one Grand Total for all the Schools. I
would like a Grand total for each company at the end of the report also.
Right now the totals for each company are related to the school.
 
M

Marshall Barton

chris said:
I have a report grouped first on School Name, then on Company

In the Company footer, I have totals for items from each Company

In the School Name footer, I have one total for all of the companies totals
combined.

At the end of the report, I have one Grand Total for all the Schools. I
would like a Grand total for each company at the end of the report also.
Right now the totals for each company are related to the school.
Click to expand...


Create a Totals (Group By) type query to get all the company
totals, then use a little subreport to present them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group Totals and Grand Totals on each page 3
Grouping Names in Mail Merge 0
Printing group totals in the page or report header 4
Trouble with my sorting and grouping 4
Totals for two groups. 0
Totals when Grouping on Two fields 1
A03 - count in report footer gives me #Error? 0
One and One-half Columns and Grand Total on Same Page (?) 5

Top