Separating a Name field into First and Last

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

I need to separate a Name field into two fields, first and
last. The format in the current Name field looks like
this: SMITH, Robert.
Thanks so much for your help...
from an Access newbie,
Kathy
 
Check Help on string functions like Instr(), Left(), Mid(), Right(). If your
entries are all consistent, you can use
FirstName:Mid([FullName], Instr([FullName],", ") + 2)
LastName:Left([FullName], Instr([FullName], ", ") -1)
If you want to change the name parts to propercase then check Help on
StrConv().
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separating Last Name, First Name into Two Fields 4
can i separate a name field into 2 separate columns? 8
Separating Last Name, First Name into Two Fields 1
Splitting a field 1
Sorting by Last Name and then First Name in the Same Field 2
Split a full name field (comma separated) into two fields 3
Trim Last Name 1
how to separate a complete name field into 2(first and last name ) 2

Back
Top