Joining 2 Queries in One Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wish to join the results of 2 separate queries in one report. The results
from one query followed by the results on the second query.

The queries as such have no direct relationship
 
Off the top of my head:

Create two reports, each one based on one of your unrelated queries. Then
create a standalone report which contains those two reports as subreports.

HTH

Rob
 
The simplest solution might be to create a 2nd report based on the 2nd
query. Then put it into the Report Footer section of the first report. The
results will print as one long list.

If the fields in the 2 queries are the same, and you want to merge the 2
lists together, another alternative might be to make a UNION query that
combines the other 2. Access can't show the UNION query graphically, but in
SQL View (View menu in query design) the statement would be:
SELECT Query1.* FROM Query1
UNION ALL
SELECT Query2.* FROM Query2
 
Thanks Rob - will give it ago.



Rob Parker said:
Off the top of my head:

Create two reports, each one based on one of your unrelated queries. Then
create a standalone report which contains those two reports as subreports.

HTH

Rob
Click to expand...
 
Back
Top