ADD "0" TO the number

[BorisGomel]

Hello everybody,
I am stuck here for a while and I hope you help me. I have failry large table called NANCAP in a database in where I upload large Excel spreadsheets. There is a filed called code and it can be one digit such as 1,2,3,and so on, and it can be two digits 22,23,50,78 and three digits 100,105. There is not problem with three digits code, but I need two 0's to be added to one and one "0" to be added to two digits code to make like this 003,009,025,050. The code uploaded like this :2,3,50,100,105 .I am trying to do that by using the update query, however I can not fugure out how to put this into query that Access will see where one "0" or two "00" to be added to the filed based on number of digits in the field.
Thank you in advance for your help.


Best Regards,

BorisGomel

[boblarson]

You can DISPLAY the value in a query by creating an alias for the field and the format function:

MyNewField:Format([OriginalFieldNameHere], "000")

That will display your field always with 3 digits.

[BorisGomel]

Thank you veru much sir.

I did made an update query to this filed "code" and put in update criteria " format([code]),"000) " .Than I incorporate this update query into macro that used to transfer excel files into Access and now it is working nicely.
A thouthand thank you .
The Best Reagrds,
BorsGomel