Keeping Zeroes in Make Table Query

[Anna]

I have gotten my make-table query to run with leading
zeroes if the field required 6 characters, however, when I
open my table, the leading zeroes aren't there.

Help!

 

[JL]

I guess the field definition is "Number" type instead
of "Text" type.

 

[JL]

You can use "format" function to force to be a Text field.
Format([A_Number],"000000")

 

[Guest]

use the format() function when displaying the field
values to get your leading zeroes.