Q: leading zero

[JIM.H.]

Hello,
I have a text field in my table that has numbers. How can I write a query
that puts some leading zeros for only numbers less than 3 digits. So if 1234
or 123 do not touch, if 12 make it 012. How can I do this?
Thanks,
Jim.

 

[Douglas J. Steele]

IIf(Len(CStr([MyNumber])) >2, CStr([MyNumber]), Format([MyNumber], "000")

 

[lepricon]

Jim,

The easiest way to do that would be to change the data type to text.

Tim