Combining Queries

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

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
 
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;
 
Back
Top