delete identical duplicate records

  • Thread starter Thread starter Jules
  • Start date Start date
J

Jules

Is there a way to delete identical records in a table where all the fields
are identical? The way I have been doing it is by creating new auto number
field so i can specify either first, last, min, or max as the criteria when i
create a distinct totals record query. Then I create a delete query. This
works but i have to add the unique column to table and them delete it later.
 
Why delete the autonumber field? Good database design usually involves
having a primary key in each table, so that records are unique. So don't
delete the autonumber field.
 
Back
Top