duplicated items

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
 
M

Mark

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
 
V

Van T. Dinh

Use the Find Duplicates Query Wizard.

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