Trying to pull same names from 2 tables

[Guest]

I have two Excel spreadsheets that I am importing from Excel. One shows a
list of Referring Physicians. The other shows a list of Non-Referring
Physicians. Periodically, a physician's name will appear on both lists. Is
there a way that I could run a query that would show me those duplicates?
Thanks, Sue

 

[Jeff Boyce]

Sue

Is there any chance that your universe of physicians includes two with the
same name, e.g., Dr. John Smith?

If so, how do you know that John Smith in spreadsheet1 is the same as John
Smith in spreadsheet2?

If you run a "matching" query between the two tables, you should find
matchting names. Whether or not those are "duplicate" names is a bit
trickier...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff - I know how to run an unmatched query. How do I run a matched query?

 

[Jeff Boyce]

Sue

Create a new query in design view. Add the two tables. Join them on their
common fields (?name).

Only those records in BOTH sources that match will be shown.

Regards

Jeff Boyce
Microsoft Office/Access MVP