Year Subtotals

[Guest]

Something is just skipping my mind. All I want to do is set up a report that
details out data by year, then give totals by year. Not one line grand
total. See below data and report structure. I know this is probably simple,
but I just can't seem to grasp it. Thanks in advance for the help

Data:
2000 A 100
2000 B 100
2001 A 100
2001 B 100

Report:

A
2000 100
2001 100
B
2000 100
2001 100
Grand Total Wanted
2000 200
2001 200

Grand Total Not Wanted
400

 

[Guest]

Use the Sorting and Grouping feature of the report writer. The first level
should use the field that has the A and B. Set a second level based on the
year.
Create Group footers for each level. The put the grand totals in the Report
Footer.