I have two tables, One for new orders coming in "Orders_T ", and another 
for orders that have been assembled "AssembledOrders_T".
I want to create a query that checks the Order_ID of both tables, then 
only selects records from the "Orders_T" that do not have a 
corresponding Order_ID in the "AssembledOrders_T".
Any help will be appreciated.

Regards
Don
Tel: +xx xx xxxxxx
http://home.swipnet.se/donlowe

the select unmatched wizard takes you through this very easily.   Go to
query new and follow the choices

Steve K


-----Original Message-----
From: DON LOWE [mailto:donlowe@s...]
Sent: 21 February 2003 16:01
To: Access
Subject: [access] Selecting Records


I have two tables, One for new orders coming in "Orders_T ", and another for
orders that have been assembled "AssembledOrders_T".
I want to create a query that checks the Order_ID of both tables, then only
selects records from the "Orders_T" that do not have a corresponding
Order_ID in the "AssembledOrders_T".
Any help will be appreciated.

Regards
Don
Tel: +xx xx xxxxxx
http://home.swipnet.se/donlowe

Steve
Thanks that has done the trick
Don
Tel: +xx xx xxxxxx
http://home.swipnet.se/donlowe