Two Tables what isn't in one that is in another

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

Guest

I have two tables that I am comparing but I need to know what isn't in one
that is in another through a query. I can get what is in both but not what
is in one but not the other. HELP!!!!
 
Diana said:
I have two tables that I am comparing but I need to know what isn't in one
that is in another through a query. I can get what is in both but not what
is in one but not the other. HELP!!!!
Click to expand...


Try using the Unmatched query wizard as a starting point.
 

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

Query that will look for duplicate in two tables. 3
Comparing Query Results 2
Problem with Cross qry 1
Counting multiple memberships 1
update query vs make query 5
Have both records from two queries/tables under one Query without related fields. 0
Query comparing two fields in a table gives wrong results-why? 3
Excel Comparing two columns 1

Back
Top