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?