Split one field into two fields

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have inherited a database where the employee name was entered as
Lastname,Firstname in the same field. I would like to be able to have a
query split the existing entry into a seperate lastname field and firstname
field.

Thanks for you help
 
Hi John

need to create two calculated fields in a query
e.g.
LastName: Left([OldName],InStr(1,[oldName],",")-1)

FirstName: Right([OldName],Len([OldName])-Len([LastName])-1)

Regards
JulieD
 
Back
Top