creating a field displaying zero values

[Steve]

I am just creating my first table.

How do I create a number field displaying 0 values.

I want the field to be a range between 00 and 99 but to display 00 or 01 and
not suppress the zeros.

It's a bit different to Excel!!

Thanks

 

[KARL DEWEY]

00 would need to be a text file due to a number field has no leading zeros.

You can have a number field that stores 0, 1, 2, 22, 23, etc. and then in
your query, form, or report format it as 00, 01, 02, 22, 23, etc.
LeadingZeroField: Format([YourNumberField], "00")