Delete Duplicate Records???

  • Thread starter Thread starter Damonj
  • Start date Start date
D

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


.
Click to expand...
 
Back
Top