Splitting Name Field into First and Last Name Fields

[Eve]

The database has over 77000 records.
The name field is such: lastname,firstname.
Can it be split into two separate fields, for example
using the comma as separator?

 

[Rick Brandt]

The database has over 77000 records.
The name field is such: lastname,firstname.
Can it be split into two separate fields, for example
using the comma as separator?

FirstName = Mid([YourField], Instr(1, [YourField], ",")+2)
LastName = Left([YourField], Instr(1, [YourField], ",")-1)

Unless there really is no space after the comma as in your post. Then the first one
is +1 rather than +2.

 

[Julie Puchalski]

The database has over 77000 records.
The name field is such: lastname,firstname.
Can it be split into two separate fields, for example
using the comma as separator?

Hi Eve,

I use Splitter for Microsoft Access to split names in Access databases.
It's designed to make this task as painless as possible.

http://www.infoplan.com.au/splitter

- Julie