IIf Statement Help

[Charandpat]

Hi, I have duplicate names(labeled CombinedName) and I want to count it as 1 for the first time it shows up and then when it shows up again in query I wanted it displayed as Counted. So I am trying to add a column that will basically show it as 1 or counted. Here is what I have so far. Desired outcome is below with the yellow circled area

[CJ_London]

show an example of the outcome as required - you appear to want to mix numbers and text in one column, and your code seems to to refer to a field called 'counted'

[Charandpat]

Desired Outcome

[Charandpat]

I can change it to 1 and 0 (instead of counted) if that is easier and keeps it as numbers

[CJ_London]

you need something unique to order the data - so in your example you have the combined name - but that is not unique, you could perhaps use hours of work, but that will fall down if teo records have the same hours. So uo need a unique ID for each row