• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

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!
0
intsup
Asked:
intsup
1 Solution
 
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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now