Delete a record every where there is duplicate

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

is there a way to delete a duplicate record in a table for
example

acct# Name
12434 Smith, John
12434 Smith, John
12222 Frank, John
12344 Jones, John

i want to only delete one of the john smith records is
there a way to do this ?
 
Go to assistance online and type how to delete duplicate records – select
Find, eliminate, or hide duplicate records in Access & scroll down & click on
I want to delete records that are duplicates of others. You will see full
explanation of how to eliminate duplicate records using Distinct Row by Query
Group Fn technique however instead of make a new table it suggests that you
use a delete query to eliminate duplicates within the original table.

Issue I have is this

My table has no relationships and I have followed MS quidelines for deleting
duplicate records where have created Totals query to find Distinct Records
and then a Delete query where fields are equal, but every run query get the
same msg cannot delete specified records. I am running it locally, table is
not locked or read only and no relationships. In my mind I have done
everything that MS advise.

What's the trick? Can anyone help?
 
Back
Top