HELP....MS Access XP(2002) Number limitation

[sin sai]

everyone...what is the limitation for a number datatype?
what is the largest number i can store? i know there are
long integer, single, double, etc? i'm trying to store a
12-digit number: 120,000,000,000, is this possible?

 

[Douglas J. Steele]

Check
http://msdn.microsoft.com/library/en-us/vbenlr98/html/vagrpDataType.asp for
the limits.

 

[Joseph Meehan]

everyone...what is the limitation for a number datatype?
what is the largest number i can store? i know there are
long integer, single, double, etc? i'm trying to store a
12-digit number: 120,000,000,000, is this possible?

Setting Description Decimal precision Storage size
Byte Stores numbers from 0 to 255 (no fractions). None 1 byte
Decimal Stores numbers from -10^38-1 through 10^38-1 (.adp)
Stores numbers from -10^28-1 through 10^28-1 (.mdb) 28 12bytes
Integer Stores numbers from -32,768 to 32,767 (no fractions). None 2
bytes
Long Integer (Default) Stores numbers from -2,147,483,648 to
2,147,483,647 (no fractions). None 4 bytes
Single Stores numbers from
-3.402823E38 to -1.401298E-45
for negative values and from
1.401298E-45 to 3.402823E38 for positive values. 7 4 bytes
Double Stores numbers from
-1.79769313486231E308 to
-4.94065645841247E-324
for negative values and from
4.94065645841247E-324 to
1.79769313486231E308 for positive values. 15 8 bytes

 

[sin sai]

Doug...

i found the Help document in MS Access:
Single = 3.402823E38 = (3.402823 * (10*38))
Double = 1.79769313486232E308 = (1.79769313486232 *
(10*308))

for Single type, i type in "999,999,999,999", it rounds
the number to "1,000,000,000,000".

for Double type, i type
in "1,234,564,567,890,123,456,789", it changes the number
to "1.23456789012346E+18".

why is MS Access doing this? is this a bug?

-----Original Message-----
Check
http://msdn.microsoft.com/library/en-

us/vbenlr98/html/vagrpDataType.asp for

 

[Douglas J. Steele]

It's not a bug: you just have to understand how computers store numbers.

Take a look, for example, at http://support.microsoft.com/?id=30601 or
http://support.microsoft.com/?id=35826

The number of bytes associated with the number dictates how many significant
digits can actually be stored.