Query so slow. was; Re: [AccessD] delete duplicates

Hello Group,

i use the query's below to delete he second or third etc duplicate from
fieldA.
It is working fine with 50 records or so. When i use it on a Table with 9000
records
query2 still runs after a few hours. What can be wrong?

TIA

Pedro Janssen


<query1/>
SELECT First(test.PK) AS FirstOfPK, test.FieldA
>From test
GROUP BY test.FieldA;


<query2/>
DELETE test.FieldA
FROM test
WHERE test.PK Not In (Select FirstOfPK from Query1);