I used the wizard query to find duplicate records from a table.  Now I'm
trying to delete those sets of duplicates but keep one record from the set.
How can I do that?

Any help is greatly appreciated.

Brandon

Brandon--
    If you are talking about true dupes (all fields the same) try this:
        SELECT DISTINCT WITHDUPES.*
        INTO NODUPES
        FROM WITHDUPES
    If you are talking about dupe keys with (potentially) different data
values try this:
        SELECT WITHDUPES.KeyVar1,...,WITHDUPES.KeyVarN,
            Agg1(WITHDUPES.DataVar1),...,AggM(WITHDUPES.DataVarM)
        INTO NODUPES
        FROM WITHDUPES
where Agg1 ... AggM are functions like MIN, MAX, FIRST, LAST
HTH, Roger