Grand total of a group

[mma40]

I have a report that I used the wizard. I have Group Level 1 of County
and Group Level 2 Types. Under each County I get the summary of each
Group in Level 2 by Type. What I am trying to figure out is how do I
get a grand total of each Type at the end of the report regardless of
the county. See below

Summary Report:
County Fulton
Type 1 $5.00
Type 2 $25.00
County Fulton $30.00

County Walton
Type 1 $10.00
Type 2 $60.00
County Walton $70.00

Report footer
Grand Total Type 1 $15.00
Grand Total Type 2 $85.00
Grand Total $100.00

Thank you

 

[Duane Hookom]

Create a subreport based on a totals query (similar to your existing
report's record source) that groups by Type. Add the subreport to your
report's footer section.