Arnold,

It is actually easier to use a Select query on the table and activate
Totals so you get unique records only, change that into a Make Table
query and produce a new table without duplicates, then get rid of the
original one and rename the new one to the original name.

Tip: back up before you try anything!

HTH,
Nikos

The following query removes all duplicates from the delegate table, leaving
only the originals of the duplicated record. Here, we define a record as
having a duplicate if there is another record with matching FirstName and
LastName fields. This query relies on a view being set up that returns a list
of duplicate delegates. The view is called DupDels.

DELETE from Delegate
WHERE DelegateID =
ANY (SELECT DupDels.DelegateID
    FROM DupDels LEFT JOIN
         (SELECT Min(DelegateID) AS DelegateID, FirstName, LastName
         FROM DupDels GROUP BY FirstName, LastName) AS FirstDup
         ON DupDels.DelegateID = FirstDup.DelegateID
    WHERE FirstDup.DelegateID IS NULL

I recently found this code as I was searching for the same issue. I have
provided an exact copy of the post I found... it is not mine and I do not
take credit.... but it DOES work!

Delegate = Your table
DupDels = Your Find Duplicates Query
Table should have an ID field. If you don't have one, copy table and add an
ID field.
    The SELECT Min(....    uses three fields, but you can add more if needed.

FirstDup = temp table (created by above query)

The way this works is it finds the Min ID of each set of duplicate records
and stores the ID, FirstName and LastName in the temp table called FirstDup.
This portion runs against your Find Duplicates query. It then uses the temp
table and deletes each record in the Delegate table that has the same
FirstName and LastName but where the ID field does not match (the original)

Make a copy of your target table, modify this query to fit your tables/fields
and test it out.

I import Excel records that contain many duplicate entries. I then run a Find
Duplicates query (stored) and then the above delete query to filter out the
duplicates.