Searching a String

[gareth001]

Hi,

I'm wanting to search a string and find where the space appears within it, once found I want to take the letters before the space and populate one feild and the letters after it in another. I was hoping I could use the same function as used within Excel (Find(" ",[FeildName],1)) to find the space, but unfortuantly not.

I know I can get this to work using Excel but would prefer to use Access if possible.

Thanks in advanced

Gareth

 

[PHV]

Have a look at the InStr and Mid functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886