Another delete duplicate

[blander]

Hi Guys,

I have run the find duplicates wizard, but as many others cannot delete the duplicates and leave one field behind.

I have the following query where it finds the records based on FIRSTNAME, LASTNAME and ORGAN

DELETE NullEmail.FIRSTNAME, NullEmail.LASTNAME, NullEmail.ORGAN, NullEmail.MemID, NullEmail.MEMBERNO, NullEmail.POSITION, NullEmail.ADDRESS1, NullEmail.ADDRESS2, NullEmail.ADDRESS3, NullEmail.ADDRESS4, NullEmail.COUNTY, NullEmail.COUNTRY, NullEmail.POSTCODE, NullEmail.SALUTATION, NullEmail.MOBILE, NullEmail.TELEPHONE, NullEmail.WORKPHONE, NullEmail.FAX, NullEmail.EMAIL, NullEmail.RATE, NullEmail.CLASS, NullEmail.ADDREF, NullEmail.DATEJOIN, NullEmail.WEB, NullEmail.Field26
FROM NullEmail
WHERE (((NullEmail.FIRSTNAME) In (SELECT [FIRSTNAME] FROM [NullEmail] As Tmp GROUP BY [FIRSTNAME],[LASTNAME],[ORGAN] HAVING Count(*)>1 And [LASTNAME] = [NullEmail].[LASTNAME] And [ORGAN] = [NullEmail].[ORGAN])));

But how do i change it so that only 1 record remains, and it deletes the other duplicates..??

If i run this it deletes all records of the duplicates..

Cheers,

Ben