If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|