Query - find a record that is in one table but NOT in another table

P

Penny

I need a query to find a group of records that appear in one table, but do
NOT appear in another table.

I'm at a loss here, and can't even think what to look up in the Help
file......

Thanks for any suggestions to head me in the right direction here.
 
C

Cheryl Fischer

If you select New Query from the database window, there is a wizard that
will create a "Find Unmatched" query.

hth,
 
P

Penny

Oh my goodness, that was far too easy! And I wasted hours trying to figure
this out on my own.

THANK YOU!
 

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

Make Table query 2
Make table query: [Enter 1] AS Test 1
NOT IN (SQL) or Find Unmatched (+ other stuff) 21
Filtering a table by using criteria in another table 1
Seriously, I need ideas. Fields not transferring from table to table 3
Multiple Table Query Is Blank 1
records that are in one table but do not have matches in another t 1
Make Table Query Assistance 1

Top