Displaying two unrealead query results under one query?Possible?

[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

 

[mikesjLFG]

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

 

[John W. Vinson]

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.

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]