Importing checking for DUPS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have trade show data that I need to load into our CRM Database. I need to
check on LASTNAME, COMPANY, and PHONE.

I can bring my CRM tables into Access along with the trade show data. And I
can query by "Find Unmatched Query Wizard" which will find records in one
table that have no related record in another table.

Can I also find where there are records the same because I have to treat
them a little differently.

The "Find Duplicates Query Wizard" only seems to find dups in a SINGLE table
or query.

Thanks in advance for your help.
 
If you want to use the Find Dups Wizard, the easiest way
is to first create and save a select query using the
tables you want to check and then use the Dups wizard
with the new query as the source.
 
Back
Top