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.

--

Ken Snell
http://www.accessmvp.com/KDSnell/


"Jules" <(E-Mail Removed)> wrote in message
news:B3959535-0745-49A4-9E20-(E-Mail Removed)...
> 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.