Integer of specific length
I am hoping somebody can help me out. I am trying to get a label to display an integer I get from a query. I need the label to be 3 digits long, so if the query returns the number 4, I want it to convert it to 004 etc. There is also the possiblility that the query will return a 2 or 3 digit number, so I cant just add 2 "0s" in front of it. Any help would be greatly appreciated.