Combining Queries

B

Brook

Good Day,

I am trying to combine two inventory queries that have the same type of
data, same number and type of fields.

I am trying to create a master query that contains all my data.

Any suggestions?

Brook
 
K

Ken Snell [MVP]

By combine, do you mean you want to show the records from both queries, as
if they were selected by one query?

Assuming yes, use a UNION query.

SELECT * FROM QueryOne
UNION
SELECT * FROM QueryTwo;
 
Top