I want to separate data (text) by the space between the words?

A

Angela Hines

Using MS Access how can I separate text in a field by the spaces? I have a
name field where the users entered first and middle name into one field and I
want to separate the data into two fields.
 
F

fredg

Using MS Access how can I separate text in a field by the spaces? I have a
name field where the users entered first and middle name into one field and I
want to separate the data into two fields.
Click to expand...

FirstName:Left([FullName],InStr([FullName]," ")-1)
MiddleName:Mid([FullName],InStr([FullName]," ")+1)
 
Top