Right/Left Function...

[GIScrew]

I am looking to take the Right(string,2) of a field. In Access, is this function performed in a query? Its been a long time since I have performed this function. Will someone refresh my memory on where to apply the necessary function phrase. Any guidance would help.
Thanks,
GG

 

[lupins46]

It would work fine in a query, assuming the field/string is available too.
In the first empty column put something like:
MyValue:Right(myfieldname,2)

where MyValue is what you want to call the result and myfieldname is your field name.