De-duplicate??

[samirkhan1]

I have a table with duplicate rows. How do I de-duplicate the table so that there are no duplicates and find out how many duplicates there were in the table.

Thanks

 

[MicroE]

Check Out:

http://www.mvps.org/access/queries/qry0008.htm

Candace Tripp's solution

 

[neileg]

You could start with the Find Duplicates query wizard.