Separate Text

N

Niki Le

I need to separate a part of a text and place them in two
separate fields. For example, a field contains the "First
Name, Last Name" and I want to separate them at the
comma. I searched help and found how to combine text but
not how to separate text. Can you please show me how to
do this in the query design view.

Thanks,

Niki
 
R

RobFMS

If you are using Access 2000 (or higher), there is a function called
Split().
This will split the text into an array that you can access. In your case,
the delimter parameter would be the comma.

Look in the help file for syntax and details.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Top