Sub Total in Access Report

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

Guest

I am trying to set up sub totals in a report. I may need to change a name of
a report footer, or insert new report footer.

example
1 item 1/1/2005 $400.00
1 item 1/30/2005 $600.00
1 item 6/1/2005 $100.00

So I would want to show a total for items (3) and Cost $900.00

then same for next year

2 item
 
shannah said:
I am trying to set up sub totals in a report. I may need to change a name of
a report footer, or insert new report footer.

example
1 item 1/1/2005 $400.00
1 item 1/30/2005 $600.00
1 item 6/1/2005 $100.00

So I would want to show a total for items (3) and Cost $900.00

then same for next year

2 item
Click to expand...


Subtotals can easily be calculated in a group footer section
text box using an expression like =Sum([amount])

In this case, I think you want to group on an expression
like =Year([the date field])

The Sorting and Grouping window can be accessed through the
View menu when the report is open in design view.
 
Back
Top