Delete Duplicate records

[Hokis]

Hi,Is there a way to delete the duplicate records within a table, or a query without doing that copy the query to a table & do the distinct thing, there must be an easier way, like in the query design view or in SQL command, please Help.
Thank you,

 

[dhookom]

If there isn't something unique to every record in a table, I doubt any SQL statement can remove/delete duplicates. You can add an autonumber key and then delete all duplicates that aren't the min of the autonumber field.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

Could faq701-5721 possibly help?

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]