Deleting dups out of a table or query

[Crazyhorse]

How do you delete the dups out of a table or query? I made a sum query. I
made a Find Dups query off of the sum query. I want to take the dups query
and the sum query join them together and delete out the dups. Is this even
possible?


Thanks

 

[Allen Browne]

You will need to use a subquery, like this:
http://allenbrowne.com/subquery-01.html#DeDuplicate

Naturally enough, your aggregating query is read-only, so you can't use it
to delete records. You also need to tell Access which one of the 2 (or more)
duplicates you want to keep. The subquery example above keeps the one with
the lowest autonumber value.

If that's too messy, a simpler way is to:
a) Create the aggregating query that gives you the un-duplicated values.
b) Use First in the Group By row under any other fields you want to retain
(such as memos.)
c) Turn this into a Make Table query.

After checking that the newly created (de-duplicated) table is right, you
can then delete your old table.