Separating First and Last names in one field

R

Rachel

How do I separate a field that contains 2 words (ie first
name and last name) into 2 different fields.

The words are divided by a space in the field.

I need to be able to do this in a query.

Thank you in advance for your help.
 
C

Cheryl Fischer

Try the following:

FirstName: Left([FullName], InStr([FullName], " ") -1)

LastName: Mid([FullName], InStr([FullName], " ") +1)


hth,
 
R

Rick B

Please do a search. This question is asked and answered almost weekly.


How do I separate a field that contains 2 words (ie first
name and last name) into 2 different fields.

The words are divided by a space in the field.

I need to be able to do this in a query.

Thank you in advance for your help.
 
Top