Q. How BIG a calculator is Access good for ?

  • Thread starter Thread starter Jim Jones
  • Start date Start date
J

Jim Jones

Hi,

In accordance with my previous post, I'd like to know how big a
calculator Access 2K is good for?

How many positions to the right of the decimal point, can Access
calculate or otherwise work with?

Thanks,
Jim
 
Your question here is different from the previous question. In the previous
question you are presumably talking about long integer data type when you talk
about incrementing by 1. Long Integer has no decimal places.

In this question since you are talking about decimal places, you are talking
about double precision. The smallest number you can represent in Access in
double precision is approximately:

4.9 / 2.7^324

that's 4.9ivided by 2.7 to the 324 power - that's mighty small (you can do the
calculation and figure out the decimal places)
 
Just to expand on that a bit further, when working in double precision, the
numbers are held with 52 bits of precision, which is roughly 17 decimal
digits. Its irrelevant where the decimal place is ( within the limits of
the 10 ^ +/- 324 exponent ).


--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top