leading zeroes

[spizotfl]

hi, i have a query that i need to export data from. i have a column that has values between 0-999. i need for that values to come out as 3 digit values
ie.
0 = 000
1 = 001
10 = 010
100 = 100
how can i make the output format this way?
thanks

 

[Golom]

Select Format(myField, "000") As [myFieldWithZeros], ...

 

[spizotfl]

that shows well in the query window, but when i export it to a text file, i only have a single zero, not 3...

 

[spizotfl]

i can't use that save formatted option because i need to have fixed width fields

 

[raskew]

Hi -

Try incorporating the Str() function. Example:

x = 99
y = format(str(x), "000")
? y
099

Bob

 

[JerryKlmns]

?
Select Right("000" & [myField],3)