Don't Drop the Zero's

[spudmizer]

We have assigned vendors numbers alphabetically so

A is allowed 0000001 - 0500000
B is allowed 0500001 - 1000000
ect.....

However when I enter it into the database it drops the all 0 infront of a number 1 or higher, so 0209301 shows up as 209301 which when sorted would put it with the letter "H"
so how do I tell it that the 0 MUST BE THERE !!!

 

[GHolden]

You could just store it as text...?

There are two ways to write error-free programs; only the third one works.

 

[PaulBricker]

If your values are numeric datatypes then all you have to do is set the format property for the Field in the Table to
0000000

That will give you the results you want.

Paul