Names

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I import information from an internet source that contains a name field
composed of the first and last names of individuals. I use this data in a
mail merge but need only the last name in one insert field. Is it possible
to use a query to extract only the last name from the name field?

Thanks
Tim
 
Yes there are "FirstName{Space}LastName" and your answer works.

Thank You
Tim

[MVP] S.Clark said:
Assuming all names are "FirstName{Space}LastName" ...

LastName: Mid$([FullName], instr([FullName], " ") + 1)

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Tim said:
I import information from an internet source that contains a name field
composed of the first and last names of individuals. I use this data in a
mail merge but need only the last name in one insert field. Is it possible
to use a query to extract only the last name from the name field?

Thanks
Tim
Click to expand...
Click to expand...
 
Back
Top