I need some help with getting the syntax of an Access expression to work. I am trying to extract the text of the first (ie left) complete word value from one field to another blank field. I am able to do this with a fixed number of characters using the following expression for eg 5 characters:
Left([FieldName],5)
but how do I do it for a variable length string? Any Access experts know the answer?
RSS Feeds
Twitter Feed
Scroll down to read the full posting
