Not matching query

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

Guest

I have made a query from 2 tables that show the matching data in 4 fields
from both tables. I want to make a query that shows the NOT-matching data
from both tables.

How exactly would I do that?

One more question, what does putting "is null" in criteria of query design
view do?
 
Jinny

The Query Wizard can help you create an "unmatched" query. Be aware that
there's more than one "flavor"!

Are you looking for all the values in Table1 that are not matched in Table2,
or all the values in Table2 that are not matched in Table1 (these are NOT
equivalent).

Or are you looking for "anything in any table that isn't matched in the
other table?"

Good luck

Jeff Boyce
<Access MVP>
 

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

Creating a Query based of two diffent data tables 1
Unique values in two fields in query 1
Access stripping decimal places in query 1
Showing un-matched fields in a basic query 4
Query Question 3
Access Dcount (multiple criteria) 3
Query based on multiple tables 2
Creating delete query based on matching fields between two tables 1

Back
Top