Finding Duplicates in 2 tables

  • Thread starter Thread starter Raj
  • Start date Start date
R

Raj

I have two tables [MainData],[Inactive] that have a
common field [EquipSerial]. How can I do a query that
will give me a list of the duplicated between the two
tables?
Thank you,
 
Raj

Define "duplicated" ... do you mean they have the same [EquipSerial] in both
tables?

If so, create a new query. Add both tables. Drag the [EquipSerial] from
one to the other. A link line will show. Add the fields you wish displayed
and run the query.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top