Combining two queries

sharrell

Registered User.
Local time
Today, 14:50
Joined
Sep 20, 2002
Messages
14
I have three queries. One that contains ALL items that have been received (qryLastRCTDate), one that has all items that have been shipped (qryLastShip), and one that contains the unmatched records (qryNoShip) i.e. the ones that have been received but never shipped.

Ultimately, I would like to combine both the items that have shipped AND the items that have never shipped to do an inventory analysis. At the moment, I have to analyze each seperately.

If anyone can tell me the best way to do this, I would be very grateful.

Thanks,
Steph
 
Use a union query.

Example from Access Help file

SELECT [CompanyName], [City]
FROM [Suppliers]

UNION SELECT [CompanyName], [City]
FROM [Customers]
ORDER BY [City];

where Suppliers and Customers are tables but you can enter query names as well. You just need to make sure that the field names or expressions names match in both queries.
 
Last edited:
Why not just use the "all" query.
 
Pat Hartman,

Do you mean a UNION query using SELECT ALL?
 

Users who are viewing this thread

Back
Top Bottom