How to grab last two digits from an integer?

[Robert_PW]

Hello all,



I hope this is the correct place for this inquiry.

Question: In the expression builder in MS Access, how can I write a statement that will grab the last two digits of an integer stored number? Just for clarification, the number may only be one digit but I still want it to be two digits (i.e. "9" would be "09", "289" would be "89" etc.). The result has to be stored as a string.

I've tried the Right() function and Cstr function and I can't get it to result in two digits.

Thank you,

Robert

[pbaldy]

Wrap your function in the Format() function:

Format(Whatever, "00")

will produce a 2-digit number like 09.

[John_G]

But Format(12345, "00") will still give you 12345, not 45.

Use the MOD operator in conjunction with the Format:

Format(Value mod 100,"00"), so Format(12345 mod 100,"00") wil give you 45, and
Format(12309 mod 100,"00") wil give you 09.

John

[pbaldy]

Certainly, which is why I said to wrap the function that is returning 1 or 2 digits in the Format function.

[RiVit]

IIf([Expr1]<10,"0" & [Expr1],Right([Expr1],2))

Replace Expr1 by variable