unmatched query

  • Thread starter Thread starter zaps
  • Start date Start date
Z

zaps

Hi there,

I have 2 tables of customers names. How do I make a query to show the
customers that are found in one table but not the other? Unfortunately, the
computer I used doesn't have the query wizard installed...as I noticed there
is a find unmatched query wizard, but I can't access it.

Thanks,
Michelle
 
Join the two by the name and elect to show both sides.
The trouble is that if it a full name then "John Smith" will not match
"John smith" or Smith, John.
(There re two spaces in the first name.)
 
join the two tables - , but change the join type from from type 1 to type 2
(or type 3 depending upon the table you choose to add to the query first)...

then select the key from both tables, and on the table where the data may be
missing, type a criteria of is null. This will show you the values from the
first table where the values from the second are not there/unmatched.

that help?
 
Back
Top