Need to convert list of names from "First Name" and "Last Name" to "Last Name" plus comma then "First Name"
Posted on 2011-09-22
We have an access table of about 800 records. The field containing the names of the participants is (First Name + Space + Last Name), I need to change them to (Last Name + Comma + space + First Name). This needs to be done only once to correct the current database because we will be using a combo box with the names in alphabetical order by last name for all future inputs. Future names will be taken from a new table which will be in the correct order.
How can I let the computer reverse the order of the names and automatically place a "comma" and space between the last and first name for each record?
Where would the command be placed? We are using MS Access version 7 in Windows.
Any assistance you give will be appreciated.