How do I list the records from a table that DON'T appear in anothe

K

Kimmck

I have a table that lists every item we have and another that lists every
item that has been sold to a certain buyer. I want to write a query that will
return every item that has NOT been sold to that buyer, ie every record that
appears in the allitems table but doesn't appear in the sold table.
Hope that seems clear, thanks for any help.
 
R

Rick B

That is an "unmatched query". The new query wizard will walk you right
through the process.
 
Top