Subtotals in a report

  • Thread starter Thread starter Aaron Howe
  • Start date Start date
A

Aaron Howe

I have a simple report which lists some data from a query
and uses a group header to split up the info. Some of the
info is an invoice value which I would like to compile and
total by group. I know how to add a subtotal to a normal
report but it only totals everything on the page as a
whole. How do I go about subtotalling specific data by
group?
 
Go to view on the menu bar and select 'Sorting and Grouping'

You can then add a group footer where you can add your total text box. To
add a footer select the appropriate group and then change group footer to
yes. When you run your report it should create a total after each group.
 
Back
Top