Showing Duplicates in table

[ericfatherree]

Can anyone explain to me how to show Duplicates in a table or filter to show them. I need to clean up the table that was imported and it has over 2500 lines.



Thanks

[alansidman]

Look at the duplicates query wizard

[ericfatherree]

Look at the duplicates query wizard

Not sure I follow your reply. I do not have a "duplicates query wizard" and when I looked to create one there was no option.

I am using Access 2000

[orange]

Access 2000 go to queries, click new, Duplicate Query Wizard should be an option in the list that is presented.