Compare 2 columns and show differences...

  • Thread starter Thread starter adambuller
  • Start date Start date
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!
 
Create a new query.
In the first dialog, pick the last option, called Unmatched Query Wizard.
 
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
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comparing lists 8
Checking if data exists another table and, if yes, extracting a value 0
Dcount returning no results!!! 0
Access Dcount (multiple criteria) 3
Word Create a Phone Book using MailMerge in word 2007 0
Access Compare records in same access table 0
Access Sequentially numbered column that resets with each new sample 0
Excel Comparing two columns 1

Back
Top