>Hi. I have a database with a lot of duplicates (but it is ok). How can I mark/delete all but the last instance of each entry? Please keep in mind that I am in v.7.
>
>Thanks, Randy
How about
DELETE FROM myTable WHERE keyfield NOT IN (SELECT MAX(keyfield) FROM myTable GROUP BY groupkey)