Thanks Jack this is what I was looking for and I am now able to make sure each id is unique when making userids by combing year, last name, first name first initial, and middle initial. So now instead of
10jonesdw, 10jonesdw I am getting what is needed 10jonesdw, 10jonesdw1.
Thanks again really appreciate the help!
Pete