Separate Text

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top