Totals when Grouping on Two fields

[Guest]

Report is grouped first on School Name, then on Company. There are payments
associated with the school and the company.

The report lists out each School name with details of payments from the
company. Company is sorted after school.
The Company footer sums all payments associated with each company, giving
one sum total for each company. The School footer then gives one total for
all companies associated with that school.

I'd like to have the same thing at the end of the report. Right now I have
one grand total for the amounts paid to all schools. I would also like a
grand total for each company, unrelated to the schools. I don't know how to
do this.

Thanks in advance!

 

[Steve Schapel]

Chris,

I think the basic approach here would be to make a separate query which
returns the Company overall totals, make a separate report based on this
query, and then insert this as a subreport into the Report Footer
section on the main report.