Switch Last Name First Name to First Name Last Name
Hello,
Access 2003. I have a single field called "Name" in a table called "Members".
There is about 300 records in a Last Name First Name format, example
Doe John
Moore Dave
Johnson Jacob Mario
(Some names have Middle Names or Sir's)
How could I run a query to change the names to First Name Last Name? Or if
you recommend in Excel how would I do this?
John Doe
Dave Moore
Jacob Mario Johnson
Thanks.
Iram
|