Seperate Name Column

[Amy]

I have a column that contains the first and last name.
How can I seperate into two columns, one for first name
and one for last name?

 

[Lynn Trapp]

Amy,
How is the column formatted? FirstName LastName or LastName, FirstName

 

[amy]

it is formatted as Last Name, First Name

-----Original Message-----
Amy,
How is the column formatted? FirstName LastName or LastName, FirstName

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm





.

 

[Lynn Trapp]

Then something like this should work:

LastName: Left([EmployeeName],InStr([EmployeeName],",")-1)
FirstName: Mid([EmployeeName],InStr([EmployeeName],",")+2)