Finding Duplicates in 2 tables

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,
 
J

Jeff Boyce

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>
 

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

find duplicates 1
Need a query to get rid of duplicates using two tables 1
Combine Duplicates in Query 0
displayFormat (non-SQL programmer) 4
find duplicates query 1
Query that will look for duplicate in two tables. 3
Deleting Duplicate Records in a single table 1
deleting duplicate records obtained from a duplicate query 4

Top