find multiply records

[GSir]

Hi i have a table with 10000 records and i want to find the multiply or the double records.Can anyone tell me how can i find this records without checking all the the records one by one

thanks

 

[willir]

GSir

Use the "Find Duplicates Query Wizard" When creeating a new query, select this wizard and run with it. It may not find everyting, but based on your description, it should help.

Richard

 

[GSir]

thank you i was try this before but its not work at all but i try now more carefull and its work