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

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

Guest

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.
 
That is an "unmatched query". The new query wizard will walk you right
through the process.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append current object to a new table 1
not in criteria fails 2
Need Help soon with this querry!!!!!! PLZ PLZ 0
Combine text values from many records into a single textbox 2
revers minus 1
Query to update qty on insert in another table 1
How to export table from outlook into ms access table? 0
Join on a calculated field 3

Back
Top