Combining Queries

[Guest]

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

 

[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;