duplicated items

  • Thread starter Thread starter David
  • Start date Start date
D

David

I would like to have a query of all duplicated items. I
don't want to delete the duplications.
What should I type in the criteria?
Thanks
 
Use a Select Query with SubTotals switched on. Select the
field that contains the data and add another field to use
as a count. Apply Descending Sort on the count field. Any
duplicates will have a count > 1
 
Use the Find Duplicates Query Wizard.

In the Queries Container window, click "New" button and the select "Find
Duplicates Query Wizard".
 
Back
Top