Easy SQL statement for Access

[Magoo5289]

I'm working on a query for a client and at the moment I'm just too busy to really research into it to find out the answer. She basically wants to have the first two digiits of a five digit number dropped off. So 00122 would show up in her query as 122. In foxpro this would be a trmlen or similar function and I thought the right command would work in access but it is saying it is an unrecognized function. In the design view I have this code... Expr1: Right([RC],3)

What am I missing? Thanks

[RobDog888]

I think the issue is not Right but rather the [RC]?
This works for me.

SELECT Table1.Test, Right(Table1.LName,3) As 3LName FROM Table1;