[RESOLVED] Access Number Data Type Question

I have some fields that need to be a number data type in my Access table. My problem is that these numbers need to be 4 digits and some begin with zeros (ie.0031). Is there anyway I can keep these as a number and not lose the zeros?

I need them to be numbers because I am usina a query with the BETWEEN Statement and getting a type mismatch on it.

Thanks for any help.

In the Access Table Design View ...

Set the Field Name, set the Data Type to "Number", and in the "General" Tab at the bottom of the window, in the "Format" parameter put the following:

0000

That will force 4 digits with leading zeros.

Quote:

---

Originally Posted by Webtest

In the Access Table Design View ...

Set the Field Name, set the Data Type to "Number", and in the "General" Tab at the bottom of the window, in the "Format" parameter put the following:

0000

That will force 4 digits with leading zeros.

---

TYVM