Splitting the Infomation Contained in a field

[Guest]

I have a field that contains a persons name Smith, John. I want to create
two fields last name and first name. Is there any easy way to accomplish
this?

 

[Douglas J. Steele]

If there's always a comma in it, you can use code like:

LastName = Left(FullName, InStr(FullName, ",") - 1)
FirstName = Trim(Mid(FullName, InStr(FullName, ",")+1))