Number formating

[GCLIFTON]

I could figure out how to search this question online, need help

I have a table in access with a field that has the number 002. How can I have that field only show 02. You know only pull the last 2 digit. I do not need all 3 just 02 aka last 2 digit

[jwhite]

If the value is 002, sounds like the field is a Text Data Type, therefore: Format("002","0#")

Replace "002" with your field name if in a query or variable name if in code.

[CJ_London]

or use the right function

right("002",2)

[GCLIFTON]

Where do I place this

[aytee111]

Leave the table to show the data as it is, with no formatting or changes to the data. Formatting is for visual display only, so you would use it in queries, forms and reports.