Deleting duplicates

[Guest]

Hi

is there any fast way to delete all duplicates of a given record in a table
(e.g. in an Access database)? Does a SQL statement exist that is able to do
this?

Thanks
Peter

 

[Mark Rae]

is there any fast way to delete all duplicates of a given record in a
table
(e.g. in an Access database)? Does a SQL statement exist that is able to
do
this?

Presumably the records can't be 100% identical, or does your table not even
have a primary key...?

 

[WJ]

"Duplicate" means a table does not support a "primary key". In this case, an
"Insert aTablewithPrimaryKey (FieldList) select distinct (FieldList) from
duplicateTable" will do the trick. Once done, delete the old table and
rename the new table.

John