Totals in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top