delete identical duplicate records

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

Ken Snell

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top