Something like
Intspaceloc = instr(CustomerName)
strLname = mid(CustomerName,intSpaceLoc,len(CustomerName-intSpaceLoc))
?
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of dbalorenzini@yahoo.com
Sent: Thursday, May 01, 2014 1:55 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Displaying a part of a string from a field
I have a table with a field call CustomerName:
Joe Blow
Jane Doe
Mark Smith
What I need is to view the last name by itself but I am not sure how to do it.
Select CustomerName from Customer.
Any Ideas?
Thank you
Arthur Lorenzini
Sioux Falls, SD
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
__._,_.___
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Now you can search Photos & Files in your Group !
You can now search not only your archive of conversations, but also photos and files stored in your Yahoo Group. Give it a try!
.
__,_._,___
Tidak ada komentar:
Posting Komentar