Access Deleting multible records in Access 2010

O

ortonben

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!!
 
MarcieFess

MarcieFess

Joined
Dec 5, 2012
Messages
3
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access 2010 import/append data into table w/o overwriting existing records 0
Access Select, Copy,Paste and Save data from subform in Access 2007. 0
Access Access 2010 auto saves objects (not records) 0
Access Access 2010: Activating controls in a form after filter by form 0
Access 2010 append query to SQL is very slow 0
Access stripping decimal places in query 1
Access MS Access Forms 1
Missing data in Access reports 6

Top