DIVIDING TEXT

  • Thread starter Thread starter Guest
  • Start date Start date
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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Commas 3
Access to split First and Last name 0
Split the contents of a field ie - full name into first and last n 3
Splitting a field 1
How to un-concatenate a field with full name 4
Split data in field on character return 0
Splitting data in 1 field 6
Mobile phone texts split into incoming and outgoing messages 0

Back
Top