Delete Duplicate Records???

[Damonj]

Hi All,
Access 2003 on WinXP Pro

I've just ran the "Find Duplicates Query" wizard and
found there are over 200 duplicate records in a table.

Other than deleting each duplicate at a time, how can I
delete all the duplicate records and just keep one of
each record?

Thanks,
Damon

 

[Wei Han]

I know how to do this in EXCEL. If you take your records
to EXCEL, (either copy paste or through "get external
data"). Construct an extra column, with formula like IF
(C2=C1, 1, 0), and just drag to form a column. So all the
rows with 1 would be the duplicated rows. Sort this
column, (don't forget to "expand the selection). Then
delete the whole chunk of "1" rows.



WH

 

[Damonj]

Thanks!!! I'll give that a try.
Damon

-----Original Message-----
I know how to do this in EXCEL. If you take your records
to EXCEL, (either copy paste or through "get external
data"). Construct an extra column, with formula like IF
(C2=C1, 1, 0), and just drag to form a column. So all the
rows with 1 would be the duplicated rows. Sort this
column, (don't forget to "expand the selection). Then
delete the whole chunk of "1" rows.



WH


.