change from 7 to 07

[mikela]

Hello all!

How can I change the one digit number to two digits numbers?? number from 1 to 10... to 01 to 09 to have 2 spaces for number?? By code...

I have no clue, and no idea where to start looking for...


Thanks in advance!

 

[Brianwarnock]

Why would you want a leading 0 in a number field?

Brian

 

[mikela]

I know it may be wrong... but i'm comparing it as string (as I have it saved in the database as string), then I need it to be the exactly the same... Too late to change it, as the death line is on friday... Do you have any idea?????????????????????????????????? I'm desperate...

Thanks!

 

[pbaldy]

Format(FieldName, "00")

 

[Brianwarnock]

Run an update query, in the update to field put

IIf(Len([fieldname])=1,"0" & [fieldname],[fieldname])

you might want to take a copy of your table first.

Brian