Search results
-
M
How can I remove the last alpha characters in a query?
WOW!!! That worked GREAT!!!!. Thank you so very much. -
M
How can I remove the last alpha characters in a query?
I have tried a variety of Right, Left, Len, Instr with no success. I will work on what you have sent, but if you have any ideas, they would be appreciated. Also I am doing this in a Query, design view. Thanks! -
M
How can I remove the last alpha characters in a query?
I have field called [LOCATION] that varies in length. I need to remove any alpha characters at the end, if there are any. Listed are some examples. [LOCATION] [NEEDED] PA 109S 55W 2N 1A PA 109S 55W 2N 1 WC 155A WC 155 PB4 68N 1UNH PB4...