# 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.

##### 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.

*Just click on the button for the Tiproom's Home Page.*

###### Date of last revision: 16 August 2001.