MS Access: Extract Last Name from a Full Name value in a query in Access 2003/XP/2000/97
Question: In Microsoft Access 2003/XP/2000/97, I'm trying to write a query that will return only the last name value from a CustomerName field. The format of the CustomerName field is:
So, if the CustomerName field contains the following value:
How do I retrieve the value "Smith"? (ie: the last name value only)
The following formula will extract the last name value from the CustomerName field:
So when we run this query, we get the following results:
As you can see, Expr1 now contains the Last Name value only.