Split one field into two fields

[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

 

[JulieD]

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