Too many digits!

[Degs29]

I have a basic multiplication expression as part of a query in the form of A*B where A is always an integer and B is a real number with anywhere between 0 and 6 decimal places. When running the query I get returned far more decimal places than are necessary. For an actual example:



10*0.07249 = 0.724899999000246

Obviously, once rounded this is the correct number (0.7249), but why is it doing this in the first place?

[orange]

Access/computers don't store the precise real number. They approximate it to various numbers of digits/bits. If you don't like the default number of decimal places, you can ask to have fewer.
see http://www.techonthenet.com/access/f...eric/round.php

Here's an analogy:

Suppose you asked someone "How far is it from the US Capitol Building to the Washington monument".

And they said
Using Google maps I find it to be
Miles 1.38390935013792
Kilometers 2.22718620918837 and

using a great circle calculation I get
Miles GreatCircle 1.38397013082645
Kilometers GreatCircle 2.22728402622381, and then

you say yea I sort of thought it was a little less than a mile and a half.

So if you don't specify how many digits (details) you want, you get the default.
And correct is in the eye of the person posing the question "What level of detail do you want/need/expect?"

startName = "Washington Monument" 
endName = "Capitol Building, Washington,DC"
startLat = 38.8894515
 startLong = -77.0348573 
endLat = 38.8899352 
endLong = -77.0091304