Concepts

What is the difference between a text field that contains numeric data and a numeric field?

Since a field of type text can hold numeric data as well as alphabetic data, it's not clear what advantage there is to declaring a field numeric. The advantages are:

1. A numeric field takes up less space than a text field.
2. A numeric field can be used in calculations.
3. A numeric field will accept only numeric data. You get a free validity check. Access won't allow you to enter alphabetic data in a numeric field.