[?] Subscribe To This Site

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


Home
Whats New!
Need a database?
Tips via email
Learn VBA
Questions Answered
Access Tips Index
What is MS Access

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