Displaying two unrealead query results under one query?Possible?

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

Guest

Hi,
I have Query1 that when executed returns 4 records under 1 field.
I also have Query2 that when executed returns 2 records under 1field.


Is it possible to combine the two results into a third query as such:

Query1 Query2
-------- --------
name name2
name name2
name
name

Does this make sense? I want to use the third query as the Record Source for
a report.

Thank you,
Alex
 
I have not personally done this before but I believe it is possible
with a union query.

you should try something like

Select * from Query1
UNION ALL
Select * from Query2
 
Hi,
I have Query1 that when executed returns 4 records under 1 field.
I also have Query2 that when executed returns 2 records under 1field.


Is it possible to combine the two results into a third query as such:

Query1 Query2
-------- --------
name name2
name name2
name
name

Does this make sense? I want to use the third query as the Record Source for
a report.
Click to expand...

No, it doesn't make sense.

There is no relationship (it seems) between the two queries, so there's no way
to join them.

I'd suggest using an unbound Report with two Subreports, one for each of these
queries.

John W. Vinson [MVP]
 
Back
Top