Hello Folks
I need to trim values in field that has the following type of format 0001.01,0001.02. Apparently there is a way of doing it by using the Microsoft Access RIGHT function based on the length(LEN) of each string.
Can anyone explain how this Microsoft Access RIGHT function works and how I would go about using it to trim my fields as noted above.
Tks
fllopez65
I need to trim values in field that has the following type of format 0001.01,0001.02. Apparently there is a way of doing it by using the Microsoft Access RIGHT function based on the length(LEN) of each string.
Can anyone explain how this Microsoft Access RIGHT function works and how I would go about using it to trim my fields as noted above.
Tks
fllopez65
