And here you all were still trying to living the nightmares that Trig classes gave you years ago much in the same way that I still have nightmares about cost accounting [the evil witch Hagler still scares me even today]

The VB works fine - its simple, its messy but it works

Private Sub Command1_Click()
Dim X As Double
Dim Y As Double
Dim Z As Double
X = 69.1 * (txtLat2 - txtLat1)
Y = 69.1 * (txtLong2 - txtLong1) * Cos(txtLat1 / 57.3)

Z = Sqr(X * X + Y * Y)
Text5 = Z
End Sub:

 It gives me two locations and how close apart they are.

What I need to do is do this in a query but i'm stuck. Perhaps it's the ambian kicking in and my keyboard mush be slipping around a tad because the keeys aren't where sthey should be.l maybe Isnuold pout on thid tomorrow.
good night



_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to