Subtotals in a report

[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?

 

[Guest]

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.

 

[Aaron Howe]

It all seems so obvious now you've said it :-D

Thanks very much!