How do you enter a 3 digit number in access?

Question

Ok here is what I need to do:
ok here's the info:
create a table called student. Each student has:
unique id number(enter a 3 digit number)(required field)
last name(cannot be blank)
first name(cannot be blank)
phone number(format 999-999-9999)
state(default NY)
sex(M,F,U)

So my question is how do I enter a 3 digit number under the unique ID number? The default it gives is a 1 digit number and everytime I try deleting it, i can't.(the numbers they give is 1 then 2 then 3,etc) It won't let me delete the number its given and therefore I am unable to give the ID number a 3 digit #. So is there a way to fix this?

Answer 1

Hi. you are correct, the unique ID is an autonumber field. Access assigns numbers to it starting from 1,2,3 etc. The person who asked you this question doesn't fully understand autonumbering.



You can, however, format the autonumber. In table design, look at the grid at the bottom. One of these says "Format". Put 000 (3 zeroes). This will show up as 001, 002, 003 etc.

Answer 2

Either a number starting with a non-zero digit or use a text field. To a computer, the number you're actually giving it when you type 001 is 1 (leading zeros are text, not numeric).

Answer 3

You need to make it an integer number with a range 100-999

Answer 4

whats the serial number?did you check for the serial number in the side of the glove box? or service history book?