I am attempting to make unique user Id's using excel or access.
I want to CONCATENATE a first name and last name into first initial last
name but if there are duplicates I want the second one to be first initial
last name 1.

ie: john doe jdoe
joe doe jdoe1
Help!
Thanks