format number in access

i have a column of months that i need to format to two digit numbers.

example:

       convert          7            to               07
       convert        10            to               10   remains same

thanks!
intsupAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:

format([month],"00")
0
 
Helen FeddemaCommented:
Bear in mind that the Format function yields a String -- it has to be a String to have a leading zero.  So you may have to change the field data type to Text.
0
 
FlysterCommented:
If the column is a date field, set the format to MM. If it's a number field, set format to 00.

Flyster
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.