This tip multiple queries in report explains how to add many queries to the one report.
These queries could be quite unrelated, but you wish to present the results for each of these queies in the one report. There are many occassions, where this maybe required and it can result in a very professional and comprehensive report.
To do this:
Microsoft Access 2007 or later instructions
(You will need to adapt this for Microsoft Access 2003 or earlier, but the instructions are very similar, so if you have Microsoft Access 2003 or earlier you should still be able to follow the instructions below.)
To create a new report, which is not bound:
Once you have created your new unbound report, you will then add each or your queries to the report.
For your first query and subsequent queries, we are going to add a subreport for each of the queries. To do this:
Your subreport will be created.
Note: By following the wizard and choosing your query, your subreport will be displayed as a continuous form. If you are not happy with the format that this process provides you with, then you may prefer to set up your subreports first, then add the subreports to your main report.
You would still follow the steps above but would choose the previously created subreport(s), rather than the query(ies).
Repeat for each of your queries/subreports, to end up with multiple queries in report.