[AccessD] Weird problem with lat/long distance function

It's a nasty workround, but this seems to work in testing:

If Abs(CosArc) >= 1 Then

It looks as though in Access 1 is not always 1.

Incidentally, try slipping this line in:

Debug.Print CosArc ^ 23


-- 
Stuart

On 23 Aug 2012 at 22:07, Mark A Matte wrote:

> 
> Thanks All,
> The problem I am having for these coordinates...is CosArc DOES = 1...or at least says it does when I step through the code...but the IF statement still goes to the ELSE.
> So...if CosArc says its 1...but really is not...how do I tell what the real value is???
> Latitude1 = Radians(41.70900431)Longitude1 = Radians(-83.585444)Latitude2 = Radians(41.7090043053031)Longitude2 = Radians(-83.5854439996183)