Conditional Updating of Duplicate Record Set (1 Viewer)

[Rich_Lovina]

This is probably a case for vb.
I run a dupes query based on 3-4 fields. Field 1stname and Field Salute (Mr, Ms) is often blank in the newer record but not in older record.

I want to update new recs such that blanks in newer dupe are filled.

Any ideas? Here's the query sql

SELECT GOVDOUG.Surname, GOVDOUG.Inits, GOVDOUG.Deptcode, GOVDOUG.[1stname], GOVDOUG.Name_ID, GOVDOUG.Salute, GOVDOUG.Poscode, GOVDOUG.F4_Deletes, GOVDOUG.GazDate, GOVDOUG.GazNr,
FROM GOVDOUG
WHERE (((GOVDOUG.Inits) In (SELECT [Inits] FROM [GOVDOUG] As Tmp GROUP BY [Inits],[Surname],[Deptcode] HAVING Count(*)>1 And [Surname] = [GOVDOUG].[Surname] And [Deptcode] = [GOVDOUG].[Deptcode]))
ORDER BY GOVDOUG.Surname, GOVDOUG.Inits, GOVDOUG.Deptcode, GOVDOUG.GazDate;

Tks in advance any help