Trim one field into two fields based on the space chacter

[Mack2]

We have imported some data. The import has combined two fields into one. I would like to break them back into two fields. There is a space in between the two values (fields). How can I trim the field once there is a space? Thanks for your help!!!!

 

[PHV]

I would like to break them back into two fields
Have a look at the Split function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Mack2]

Hi PHV,

Thanks for the reply.

After reading up on the split function, I thought it would work. But The query designer does not recognize the function. And it seems like there has to be a quicker way to do this than writing a function. Is there a function that will find the space and can be used in the query designer?? THANKS FOR YOUR HELP!

 

[PHV]

Have a look at the Left, InStr and Mid functions.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886