Seperate employee name

[John]

I am trying to append employee table from an old database into a new
database.

I have a field [OldEmployeeName] with Employess FirstName, Initial, LastName


with a querry I need to get FirstName and insert in field named
[newFirstName]
with a querry I need to get Initial and insert in field named [newInitial]
with a querry I need to get LastName and insert in field named [newLastName]

 

[Jeff Boyce]

John

Consider using the Left(), Mid(), Right(), and InStr() functions to "parse"
the field into pieces. Or, depending on which version of Access you are
using, I believe there's a Split() function.

Another approach, if you have an older version, might be to export to Excel
and use Excel's splitting function.

By the way, any [OldEmployeeName] that lacks a middle initial will not be
split correctly -- you may still have some manual cleanup to do.

Regards

Jeff Boyce
<Office/Access MVP>