Update first record of duplicates

[OldCityCat]

I'm looking for a simple way to:

1. Find duplicate records in a table based on a single field(could be up to 6 dups)
2. Update First record with data for two fields from each duplicate
3. Delete duplicate records

Thanks in advance for any and all suggestions
OldCityCat

[ItsMe]

Since you only want to update certain records within your original query I would approach this using a DAO or ADO recordset and run a loop.

I am a little confused about number 2? Where is the data you collect originating from?