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.
|