unmatched query

[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

 

[Mike Painter]

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.)

 

[Arvin Meyer]

Try something like this:

Select * From Table1
Left Join Table2 on Table1.ID = Table2.ID
Where Table2.ID Is Null

substituting your table and field names.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[TracyG]

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?