Names

[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

 

[Tim]

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

Thank You
Tim

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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

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