Splitting One Field into Two

  • Thread starter Thread starter Pauline
  • Start date Start date
P

Pauline

I imported data from Word Perfect to text then to Access.
I would like to split the name field into two fields,
FirstName and LastName.
 
Assuming a space between a firstname and lastname use this to extract for
the firstname in a query
FName: Left([Name],InStr([Name]," ")-1)

use this for the lastname in the query:
LName: Mid([Name],InStr([Name]," ")+1)

If you have a comma then just add that value between the " " like this ","
 
Back
Top