Free E-Books

Notice that you did not specify a field size for the Memo data type. Access allocates as much space
is necessary for the memo data.
NOTE NOTE
48
Access Building Blocks Part I
Number data type
The Number data type enables you to enter numeric data; that is, numbers that will be used in
mathematical calculations. (If you have data that will be used in monetary calculations, you should
use the Currency data type, which performs calculations without rounding errors.)
The exact type of numeric data stored in a number field is determined by the Field Size property.
Table 2-3 lists the various numeric data types, their maximum and minimum ranges, the decimal
points supported by each numeric data type, and the storage (bytes) required by each numeric
data type.
TABLE 2-3
Numeric Field Settings
Field Size Setting Range Decimal Places Storage Size
Byte 0 to 255 None 1 byte
Integer ??“32,768 to 32,767 None 2 bytes
Long Integer ??“2,147,483,648 to 2,147,483,647 None 4 bytes
Double ??“1.


Pages:
233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257