Deciding Number Types
When assigning the Number data type to a field, you may have trouble deciding which Field Size property to use--there are several. The following guidelines may be of help to you:
- Byte: This type requires the least memory and is also the most limiting because you can enter only integer values from 0 to 255.
- Long Integer: Stores integer values, both positive and negative, inclusive of -2,147,483,648 through 2,147,483,647.
- Single: Stores values with decimal components (fractions) between -3.402823E38 and -1.401298E-45 for negative values and 1.401298E-45 and 3.402823E38 for positive values (four or fewer decimal places). Note scientific notation is used because of the large size numbers.
- Double: Stores values with decimal components between -1.79769313486232E308 and -4.94065645841247E-324 for negative values and 4.94065645841247E-324 and 1.79769313486232E308 for positive values.
- Replication ID: This one most of us won't use because it accepts GUIDs (globally unique identifiers).
- Decimal: Stores values from -10^28 - 1 through 10^28 - 1.
Decimal is a new number type to Access 2000.
Just click on the button for the Tiproom's Home Page.
Tip comes from Susan Sales Harkins, a private consultant specializing in Access and VBA development. She currently has two technical books on the shelves: "Using Microsoft Access 97" and "Using Microsoft Access 2000." Both are QUE publications.
Date of last revision: 16 August 2001.