Subtotal in a report

[millerlite2ky]

I've made a report based off of a table. I have used Sum & Count for various records in the Footer section. Now I'd like to subtotal by year within the report, without disturbing the grand totals for the original group.
Any Ideas would be appreciated.

Scott

 

[SydneyGeek]

Try grouping by year, and adding the subtotals. The following assumes that you have a Year field --
In Design view:
View | Sorting and Grouping
Add Year to the list. Sort Ascending.
In the dialog below, set Group Footer to Yes
(You can play with the order of the grouping levels to get the desired result.)
Copy and paste the Totals fields from the Report footer to the new Year footer.
You should get subtotals for each year, inside the original structure that you set up. The footer will show the grand totals.

Denis