answersLogoWhite

0

This is true in any database (Access, Oracle). A number field is technically called a "NUMERIC" field. Only numbers can be inserted into a field that has this designator. A text field is for characters or numbers. It can be a "CHAR" (character), a VARCHAR (characters or numbers). It's basically a way of putting rules on columns--what type of data belongs there.

User Avatar

Wiki User

17y ago

What else can I help you with?

Related Questions

Can you convert a currency field to a number field in access?

ya sure we can do for convert a currency field to a number field.


In a clinical field trial what is the difference between normal range and reference range?

It is the biggest number subtracted by the lowest number= your answer


What is the difference between a field survey and a field experiment?

differentiate between field experiment and survey and advantages


What is the difference between bench and field springer spaniel variety?

whats the difference in temperament between field springer spanialels and show.


What is the difference between you do and you play in sports?

I do track and field


What is the difference between field crops and pastures?

nofin


What is the relationship between the electric field between two plates and the potential difference across them?

The electric field between two plates is directly proportional to the potential difference across them. This relationship is described by the equation E V/d, where E is the electric field, V is the potential difference, and d is the distance between the plates.


What is the maximum number of characters a text field can store in Microsoft access?

32,767 characters in a standard text field.


What is the difference between a drainage field and a seepage pit?

One is a drainage field, and one is a seepage pit.


What is difference between a trap gun and a field gun?

Mainly in the stock


What field with the data type can store a unique sequential number that Access assigns to a record Access will increment the number by 1 as each new record is added?

AutoNumber


A field with the data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.?

AutoNumber