Year Subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top