Renaming Duplicates

[brewpedals]

I'm using a Access97 query to rename assets in another database based on a set or criteria. Unfortunately, this criteria creates some duplicates that will need to be corrected manually in the other database. So, I'd like to "mark" the subsequent duplicates by appending the asset name with the text "(Duplicate)" and leave the first instance unchanged.

Here's the SQL I'm working on. Unfortunamely, it renames all the duplicated asset names.

UPDATE DISTINCTROW NewLines SET NewLines.[New Line] = [New Line] & " (Duplicate)"
WHERE (((NewLines.[New Line]) In (SELECT [New Line] FROM [NewLines] As Tmp GROUP BY [New Line] HAVING Count(*)>1 )));

I tried changing the criteria statement to ...HAVING Count(*)>2))); with no success.

Your suggestions are very much appreciated.

BP