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.