Splitting up a Name Field

[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!

 

[[MVP] S.Clark]

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

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!