Query for Duplicates and Use Update to Add New ID

[JustALittleHelp]

I'm converting an Excel table listing Employee awards to a database
application;

1 ID and record per award year (employees listed each time they receive 5 |
10 | 15 | etc YR award.)

In Normalizing tables:
I've created a find duplicate make table query that'll be used as step 1 to
create the employee table;

I've added an employee ID column to the table.
Now I need to update that column so that each duplicate is numbered with the
same number (I'll eliminate duplicates later)

The WHERE part of the find duplicates statement looks like this:
WHERE
(((Staff_Service_Awards.NAME)
In (SELECT [NAME]
FROM [Staff_Service_Awards]
As Tmp
GROUP BY [NAME],[EMPL DATE]
HAVING Count(*)>1 And [EMPL DATE] = [Staff_Service_Awards].[EMPL DATE])))

I'm not sure how to move beyond this...