K
Kevin O
How do you split a full name in one field into two fields
(last name ans first name)?
(last name ans first name)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
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)
K
KevinO
Sorry I wasn't more explicit. My Full Name field is
formatted like this:
John Doe
Sally Beach
Don Rose
formatted like this:
John Doe
Sally Beach
Don Rose
F
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)
K
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.
.
G
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
BDP