How to query a record that doesn't exist?

[veraloopy]

Sounds a little odd I know.....

I have several tables that are linked to eachother, the primary key is the same in all tables, i.e. in tblCustomerDetail the primary key is 63 and in tblCustomerOrder the primary key for the same customer is also 63
I then have another table tblOrderShipped which, when an order is shipped will also have the primary key number 63

I need to create a query that tells me every customer who has an order date in the tblCustomerOrder that does not have a record at all in the tblOrderShipped table.

This will then tell me any outstanding orders that haven't yet been shipped.

I've created a simple query to show these fields where the order shipped flag is false but as that record doesn't exist in the tblOrderShipped table, the query is returning no results....

Any ideas?

Many thanks in advance

 

[khawar]

Use the unmatched query wizard

 

[veraloopy]

Many thanks Khawar

Sometimes, I spend that much looking deep into access that I miss the simple most obvious things!