Delete duplicate values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a table where I have a field called name. But there is a lot of
equal names. How can I delete all the duplicated records and leave in the
table different names.

Thanks in advance.
 
Have you done a search? This is a very very common question.

Read the previous posts on the topic and follow their advise. No need for a
new thread.
 
David

"Name" is a reserved word in Access. Consider coming up with a somewhat
more descriptive fieldname that doesn't confuse Access (how will Access know
which "name" you are referring to?).

One approach is to create a new table with the same structure, put a unique
index on the field(s) containing your names, then append records from the
old table to the new. Any "duplicates" will be rejected by the unique
index. NOTE: if your records are in a 1-m (i.e., "parent") relationship
with other tables, you could lose the connection by doing this!

Regards

Jeff Boyce
<MS Office/Access MVP>
 
Back
Top