If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
unmatched query
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 |
#2
|
|||
|
|||
unmatched query
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.) "zaps" wrote in message able.rogers.com... 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 |
#3
|
|||
|
|||
unmatched query
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 "zaps" wrote in message able.rogers.com... 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 |
#4
|
|||
|
|||
unmatched query
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? |
Thread Tools | |
Display Modes | |
|
|