Splitting Full Names into two fields

[Kevin O]

How do you split a full name in one field into two fields
(last name ans first name)?

 

[fredg]

How do you split a full name in one field into two fields
(last name ans first name)?

That all depends.
If the present full name field is exactly like this (comma separated):
Smith, John
Van Buren, Martin
Then you can use
LastName:Left([FullName],InStr([FullName],",")-1)
[FirstName:Mid([FullName],InStr([FullName],",")+2)

 

[KevinO]

Sorry I wasn't more explicit. My Full Name field is
formatted like this:
John Doe
Sally Beach
Don Rose

 

[fredg]

Sorry I wasn't more explicit. My Full Name field is
formatted like this:
John Doe
Sally Beach
Don Rose

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

 

[Kevin O]

Thanks so much, you the man

-----Original Message-----

Sorry I wasn't more explicit. My Full Name field is
formatted like this:
John Doe
Sally Beach
Don Rose

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

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

 

[Guest]

Is this occamplished through an update query? I need to do the same thing but am unclear of how to accomplish this, seems like a fairly common issue / mistake

BDP