LTrim Help Needed.

[DaveShmave]

Hi All,

I want to trim all in a text field except the last letter / value. So if I trimmed 'DaveShmaveX' (without the quotes), I'd only be left with X. I've looked at the online help and have messed around with this for a while with no success.

Can someone clue me into how you'd trim all but the last letter / value?

TIA

Dave

 

[JerryDennison]

The function is:
Right([FieldName], 1)

 

[DaveShmave]

Cool Thanks!

Dave