Compare 2 columns and show differences...

A

adambuller

I'm sure the is probably an easy one for everyone (but me) but here it
goes...

I have a master table (Table A) with a column containing all records
(i.e. Telephone numbers).

I have second table (Table B) that is a subset of the first.

I would like to run a query to see what numbers are in Table A and NOT
in Table B.

I played around with a "Not In" statement but didn't have any luck.

Any help would be appreciated!
 
A

Allen Browne

Create a new query.
In the first dialog, pick the last option, called Unmatched Query Wizard.
 
S

strive4peace

Hi Adam,

make a query based on both tables

link on Phone Number

right-click on the link line

choose to see all records in table A and just those records in table B
where they match

on the grid, put the primary key field for table B
criteria --> is null

then, show the phone number from table A

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Top