Grand totals from grouping totals

[Nickaroo]

How can I get Grand totals for 2 of 3 grouping levels at the report footer?

Grouping levels as follows:
Grouping Header Section

Date
Division
Activity

Group Footer Section
Date =sum([total rate])
Division =sum([total rate])
Activity =sum([total rate])


Report Footer

I want grand totals for each group: Division & Activity

 

[dhookom]

If you want to repeat your group footers in your report footer, you can create a Group By/Totals query that is similar to your report's record source. Total the [Total Rate] field. Then use this totals query as the record source of a subreport that you place in the report footer.

Duane
MS Access MVP