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.

 

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