Totals in a report

[Guest]

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.

 

[Marshall Barton]

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.

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