S
sUSAN
HOW CAN I SPLIT A FORMAL NAME INTO A FIELD FOR FIRST NAME AND LAST NAME?
R
RobFMS
Susan
Please don't put text in all caps... (its referred to as shouting in the
digital world...)
Access 2000 and up has a function called Split() that you can use. (See help
file for more information).
Are you always going to have FN <space> LN for the names? Will you have a
middle name? A prefix/suffix?
--
Rob
FMS Professional Solutions Group
http://www.fmsinc.com/consulting
Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Please don't put text in all caps... (its referred to as shouting in the
digital world...)
Access 2000 and up has a function called Split() that you can use. (See help
file for more information).
Are you always going to have FN <space> LN for the names? Will you have a
middle name? A prefix/suffix?
--
Rob
FMS Professional Solutions Group
http://www.fmsinc.com/consulting
Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-