The following is a description of the common numeric types for access and the range of values that are listed for reference
Number Type Range
A byte (byte) integer number between 0 and 255.
Integer (integer) The number of short integers from –32,768 to 32,767.
Long (long) is a number from –2,147,483,648 to 2,147,483,647.
The Currency (currency) is between -922,337,203,685,477.5808 and 922,337,203,685,477.5807.
Single, single-precision floating-point number. When the range is negative.
From -3.402823E38 to -1.401298E-45,
And in positive numbers, it's from 1.401298E-45 to 3.402823E38.
Double, double-precision floating-point number. When the range is negative.
From -1.79769313486231E308 to -4.94065645841247E-324,
And the positive number is
From 4.94065645841247E-324 to 1.79769313486232E308
Decimal (decimal) precise numeric data type.
The variable is stored as a 96-bit (12-byte) signed integer shape,
and divided by a power of 10. This variable factor determines the number of digits to the right of the decimal point,
It ranges from 0 to 28. If the ratio factor is 0 (no decimal digits),
The maximum possible value is +/-79,228,162,514,264,337,593,543,950,335.
And in the case of 28 decimal digits,
The maximum value is +/-7.9228162514264337593543950335,
The smallest non-0 value is +/-0.0000000000000000000000000001.
You can define the accuracy (1-28) and
Numeric range (the maximum number of digits that can be stored after the decimal point).
The default precision and value ranges are 18 and 0, respectively.
Description and range of values for access common numeric types