duplicated items

[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

 

[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

 

[Van T. Dinh]

Use the Find Duplicates Query Wizard.

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