trimming characters

[razorking]

Is there a way to trim all but the 1 most right characters of a field?

In other words: I have field of which I would only like to see the last character of text. The text leading up to the last character can vary in length.

 

[KenHigg]

MyStr = Right(AnyString, 1) ' Returns "d".


Straight from vbhelp

???
kh

 

[razorking]

Thanks Ken

Thanks for the help. Unfortunately I am stupid and therefore am unable to do anything in VB. My current skill set restricts me to QBE and SQL stuff.

I believe I found another way to accomplish my objective though.

Thanks anyway for the quick response.

 

[KenHigg]

Unfortunately I am stupid ...

Browse 'The Watercooler' forum and you'll form quite a higher opinion of yourself...

kh