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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The lowest of all? 6
Report Detail in Two Columns 4
Access 2007-Report by Month; Year to Date Total 2
Subtotals, not re-initializing 2
Subtotal for each vessel 4
Sum one field if another field is equal to something 10
Reset running sum on group level 2
summing in a query or report 4

Back
Top