Delete all records from a table that match records in a duplicates query I have made?

[accessbunny]

Hello,



I made a query for duplicates called Dupes, and then a second query called Unwanted that only shows the Max of ID for each duplicate (So it lists 1 of each duplicate record for todays date).

Basically, I want to delete all records that match MaxOfID field from the Unwanted query to the ID field in my table MasterRoster. What can I put in the criteria box for my "Where" to make it do this?

(No, I cannot prevent future duplicates. This query will be ran on a regular basis by the team being given the database because they tend to input duplicate entries and want an easy way to clear them out each day.)

[CJ_London]

create a delete query something like

DELETE *
FROM MasterRoster
WHERE ID IN (SELECT MaxofID FROM Unwanted)

[accessbunny]

That worked, thank you very much!

[CJ_London]

you may have to run it several times if your users have entered more than two duplicates