I have a company employee mailing list and a new employee mailing list.
I need to open an email for new employees. I"ve been using excel manually. I want to try to use access to automatically achieve
. I need to query the duplicate name and add the number (XXX) after the duplicate employee"s name to distinguish, for example, there are three new employees in the general list: three, 001, three, 002, three, three. There are three Zhang San I hope to turn these three big cats into Zhang San 004 Zhang San 005 and Zhang San 006 and add them to the general table

I can query the duplicate name now, but I don"t know how to choose the name part of the general table when querying the same name. For example, my newcomer"s name is Zhang San. I need to show 001-003 in the query result before I can know that Zhang San wants to add 004. I want to query Zhang San and Zhang San, not Zhang San and Zhang San 001, because that is not repetitive