Here's the problem and I understand that a few folks have responded to this already and I appreciate their effort, but the problem is still unresolved. I have a text field in a table called [Address]with data like this: 234 Elm Street (ZIP 2345). In a query, I want to rename the field to New Address and trim off the right-most nine characters so that the query result will be 234 Elm Street, with no (ZIP 2345). Just how can we do this? What would be the expression in the query? Thanks beforehand to all trying to assist. Please let me know soon.
Trimming a text field, still unresolved
- Thread starter fhs
- Start date
Here's the problem and I understand that a few folks have responded to this already and I appreciate their effort, but the problem is still unresolved. I have a text field in a table called [Address]with data like this: 234 Elm Street (ZIP 2345). In a query, I want to rename the field to New Address and trim off the right-most nine characters so that the query result will be 234 Elm Street, with no (ZIP 2345). Just how can we do this? What would be the expression in the query? Thanks beforehand to all trying to assist. Please let me know soon.Just tried it. The field data is typically 3456 West Elm Street (ZIP 3456). I placed "New Address:Left([Address],(InStr(1,[Address],"(")-1))," (without the quotes, of course) and the query result was 3456 West Elm Street (ZIP 2345). What should I try next? 
