3 Queries 1 Field

[Esoteric]

I need to know if there is a way to combine 3 Queries into 1 field result. I have the following:

Query1 : Field1
Query2 : Field1
Query3 : Field1

I need to have the result of:

Query1 : Field1

with the results from all 3 into one field.

 

[tlbroadbent]

Have you tried a Union Query?

Select field1 From query1
union
Select field1 From query2
union
Select field1 From query2
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.