Slightly longer winded but it works-
Create new query - Find duplicates query wizard.
After done, open this query and delete all unwanted records, leaving only the ones needed.
Try this out on a copy of the table first - cos when you delete records on a query it will alter the table.
If happy with results then delete orig table and use this one!