Combine Main Report with subreport

[jortizz]

Microsft Access 2007
I want to combine two reports into one report. I have one report which I'll call HeaderReport. This combines YTD sales information by category for all of our accts combined. It has only 20 rows or so.



Below that I would like a breakdown of all of these categories by Acct Name. So that below the HeaderReport I'll have each acct name followed by all the sales information for each category. Repeat for each account name, but I only want the HeaderReport summary once at the very top. How could I achieve this? This is my first time working on reports so still not quite sure if this is even possible. I'm trying to use subreports but since my subreport and main report are in the "Detail" section my report does not look right. Any suggestions?

[June7]

Use the parent report Grouping & Sorting features to organize the account detail info (not a subreport, this is on the main report). Put the HeaderReport subreport in the Report Header section then it will show only on the first page of report.

[jortizz]

Put the HeaderReport subreport in the Report Header section then it will show only on the first page of report.

Thank you so much. This worked