answersLogoWhite

0

Autonumber will automatically increment whenever a new record is inserted.

The Number data type is just what it says: it's just a number. It doesn't increment automatically. It's just a column that can ONLY take integers that you insert into it.

User Avatar

Wiki User

13y ago

Still curious? Ask our experts.

Chat with our AI personalities

BeauBeau
You're doing better than you think!
Chat with Beau
FranFran
I've made my fair share of mistakes, and if I can help you avoid a few, I'd sure like to try.
Chat with Fran
ProfessorProfessor
I will give you the most educated answer.
Chat with Professor

Add your answer:

Earn +20 pts
Q: What is the difference between an AutoNumber and Number in Access?
Write your answer...
Submit
Still have questions?
magnify glass
imp