Report Summary with subtotals

[Guest]

The report that have I would like to generate a subtotal for a group of
records, then take that subtotal and have it show up on a summary page at the
begining of the report. Then a final total will be calcualted.

Example:

Say I have 100 PO's grouped into 7 categories. The report will list the
PO's by category, each category on a seperate page, with a subtotal at the
bottom of the page (or Group Footer). The trick now is to take that
calculated subtotal and put it into a summary page (or Report Header) so that
I can see what the totals are for each category and the grand total for all
PO's.

 

[Duane Hookom]

Create a totals query that groups by the categories and totals whatever. Use
this totals query as the Record Source of a subreport that you can place in
your main report Header section.