Easy SQL statement for Access
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