Separating a Name field into First and Last

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
 
D

Duane Hookom

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