Select FIRST word

[Pete666]

I'm trying to create a query that gives me the first word in a field but am having some difficulties.

I'm using Access 97 (Dated I know) but also have Access 2003 if I need to revert as a lot of code does not work on 97.

Any help appreciated.

Pete

 

[namliam]

Look at the left and instr functions

 

[vbaInet]

Have a look in the Help Files on the useage of the SPLIT() function.

Dim myArray() as String, firstWord as String

myArray = Split("this is my string", " ")

firstWord = myArray(0)

 

[Pete666]

cheers, I'll check on Split, Left and Instr.