With MS Access, I need to find a way to eliminate duplicate username in a table. I work at a Community college and I am the person who takes care of the importing of students onto our Novell Network. I download a list of all students (First,MI,Last,SS,School Code). Our current standard is first initial of first name then seven char of last name. When there is duplicate username I replace the last char with a number. Is there a way to automatically do this with a query?