Splitting up a Name Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 97 and need to split up a name field. The name field in the table has the complete name (e.g. Smith, John J.). I need a query to make a new table that separates the name into 3 different fields for first, last, and middle names. Any help would be appreciated. Thank you and Happy Holidays!
 
InfoPlan's Nameparser does it, or you can roll your own using Left$, Mid$,
Right$.
http://www.infoplan.com.au/nameparser/
--
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Dave said:
I am using Access 97 and need to split up a name field. The name field in
Click to expand...
the table has the complete name (e.g. Smith, John J.). I need a query to
make a new table that separates the name into 3 different fields for first,
last, and middle names. Any help would be appreciated. Thank you and Happy
Holidays!
 
Back
Top