When attempting to format text using the Right(stringexpr,n) function in expression builder, I continually receive the error message:

"Ambiguous name. in query expression 'Right([table]![field],2)'."

I've used this function many times to truncate text, however, this is the first time I've tried this since going from MS Access 2000 to 2002/SP2.

Wondering if this is a software code problem? I get the same result at other PC's with similar upgrades.