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
Quote:
>I'm trying to delete duplicates
>Brandon