Unmatched Query Issue

[Guest]

I created a “Find Unmatched†Query – comparing a table and a query.
The table has 1787 records and the query has 1730 records. I set up this
same query on another database and everything worked out fine. This one is
not finding any unmatched records. Maybe I’m asking too much to figure this
one out. It probably be several reasons. Am I right?


Thank you

 

[John Spencer (MVP)]

Could it be that the field(s) you are comparing in the table have duplicate
values. If a record in the query matches two records in the table then there is
a match - just not a one to one match. Simplistic example follows.

Table has three fields with values
A, B, C
A, B, D

Query has one record with values
A, B, F

If you do an unmatched query on the first two fields, there will be no
non-matched records.

The first record in the query will match both of the records in the table.