Incremental Query Number

[PeterK]

(I have posted this elsewhere last week but no response)

I have a find duplicates query that gives me a duplicate
value and the number of duplicates for each duplicate
item. I would like to add another column to the query
that adds a incremental number for each item for later use
in a DLookup function. Is this possible? If so how?

Thanks

EX:

Item #Duplicates Increment
Apples 4 1
Oranges 3 2
Carot 10 3