Combine two querrys to one report

G

Guest

I have two separate queries that don't relate in any way. I would like to
combine the two results of these queries on one report. I have tried to
combine the queries into one but have not been sucessful since they are
unrelated in any way. I'm thinking I want to use a subreport, but don't know
how.

Thanks,
New user who needs help
 
D

Duane Hookom

A subreport is similar to any other report. It is added to a main report in
much the same way you would add any other control. It is very similar to a
subform on a main form.
 
A

Allen Browne

1. Create a report that lays out the data the way you want for the 2nd
query. Save. Close.

2. Create another report that lays out the data for the 1st query.

3. If you do not see a Report Footer section at the end, click Report
Header/Footer on the View menu. Now drag the report you created in step 1
above from the Database window into the Report Footer section on this
report. This gives you a subreport in the Report Footer section.

To tidy things up, you may need to make some changes to the report that is
the subreport. The Page Header and Page Footer don't work in a subreport
(because the pages are defined by the main report). If you wanted like
column heading labels that should repeat on every page, use the Sorting And
Grouping dialog (View menu) to create a group header in the 2nd query's
report, and set this section's Repeat property to Yes so it shows at the top
of each page.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top