move data in a field

[Guest]

I have a database in which the first name, (some have middle initial) and
last name are all in a "Name" field. Is there a way to move them to their
own individual fields, Last name, First name, and Middle initial fields??
Access 2003.

 

[fredg]

I have a database in which the first name, (some have middle initial) and
last name are all in a "Name" field. Is there a way to move them to their
own individual fields, Last name, First name, and Middle initial fields??
Access 2003.

You need to post back with a bit more information.
Exactly how are the names written, i.e.
John Doe
J. Edward Doe
John Doe, Jr
Doe, John
Doe John
Doe, John C.
Doe, Jr, John
etc.

If all entries are in the same format, it can be done. If the formats
are mixed, you'll need to first get them all the same.

Anyway, look up the Split() function in VBA help, as well as the
InStr, Left, Mid, and Right functions.