P
PeterK
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
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