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().
 
Back
Top