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?"
Code:
startName = "Washington Monument"
endName = "Capitol Building, Washington,DC"
startLat = 38.8894515
startLong = -77.0348573
endLat = 38.8899352
endLong = -77.0091304