Joining 2 Queries in One Report

[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

 

[Rob Parker]

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

 

[Allen Browne]

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

 

[Guest]

THanks Allen this also seems a solution and I will give it ago.

 

[Guest]

Thanks Rob - will give it ago.

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

 

[Guest]

Allen, your second report process worked like a dream thank you.


Regards


Juparo