Home
What is MS Access
Tables
Forms
Queries
Reports
VBA Codes
Learn VBA
Access 2007/10
Access 97
Tips via email
Whats New!
Contact Me
Questions Answered

[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines


Multiple Queries in Report

 

 

Question:

How do I create a report wherein I combine multiple queries in report that shows one query on top and the other query on the bottom?

 

Answer:

To create multiple queries in report, try the following:

Open a report in Design view (i.e. do not base it on any table or query). On the toolbox, click on the subreport button, this will start the subreport wizard. Work through the wizard choosing your first query.

 When finished, repeat the procedure for your second query.

 This will add the two queries to your report.

 

 

 

Do you like this tip? Subscribe to my free Newsletter to receive tips via email. Click Here to subscribe.

 

www.simply-access.com (c) 2008