Totals when Grouping on Two fields

G

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!
 
S

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.
 

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

Top