Generating a number

  • Thread starter Thread starter Question Boy
  • Start date Start date
Q

Question Boy

Hello,

I don't think this one is complexe, I've just never had to do it.

I have to genearate a sequential number. As such, I use DMAX to determine
the greatest value in the table and then add 1 to it. Nothing Complexe!
However, where I need help is with the fact that right now I get values
1,2,3,4,5,.... and I would like to get 001,002,003,004,....

How can I tweak my code to do this? Is there a function that I am unaware of
the can convert 1 to 001, etc.?

Thank you,

QB
 
Open your table in design mode and change the format of the number field to
000.

Ken
 
Back
Top