Access Deleting multible records in Access 2010

Joined
Nov 30, 2012
Messages
3
Reaction score
0
Hello,

I have been looking everywhere online to try and find a way of deleting multible records in an access database. I have a table with 3275 records, from where customers have requested brochures, however some customers have entered their details more than once (around 190 customers, with 422 lines in the table) and I need a way of deleting all of these records, but to keep 1 orginal.

Hope someone can help.

Cheers!!
 
Have you tried to just use the Find Duplicates Wizard under Create/Query Wizard? If that doesn't get you close enough, let me know and maybe I can help you pinpoint it a bit more.
 
Back
Top