Find Missing data

  • Thread starter Thread starter Ljackson
  • Start date Start date
L

Ljackson

I have two tables that link on a common field and I need to find records that
exist in one of the tables but not in the other. I'm not sure how to write
my query to do that.
 
From the database window, click on the <New> toolbar button's drop-down
arrow, select Query, then follow the query wizard's instructions for
"unmatched query".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You must log in or register to reply here.

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

Access Dcount (multiple criteria) 3
Make table query: [Enter 1] AS Test 1
Query with common fields to all records 6
Split data in field on character return 0
Have both records from two queries/tables under one Query without related fields. 0
Need a query to get rid of duplicates using two tables 1
appending new records to a table with a compound primary key 9
Seriously, I need ideas. Fields not transferring from table to table 3

Back
Top