Go to Sorting and Grouping and group on a field that groups your data to be
able to get the subtotals you want. You will get a Group Header in your
report. Click on the Group Header to get its properties. Set Group footer to
Yes . Add a textbox named Subtotal in the Group Footer and set its control
source to:
=Sum([NameOfFieldYouWantSubtotalFor])
Put a textbox named Grand Total in the report's footer and set its control
source to:
=Sum([Subtotal])
