Will this formula work in Access (distance between Lat/Long points

E

efandango

I am trying to work on a query that will give me the distance between two
geo-points.

My question is will this formula work 'as is' within Access or do I have to
make some alterations. The formula uses the 'Great Circle Distance'
calculation. I'm not very good at high maths/trig, so was hoping that I could
somehow paste this into a VBA function and use it with adjusted field
references (Lat/Long). I found the formula elsewhere, and it works perfectly
in Excel.

=RadiusEarth*ACOS(COS(RADIANS(90-(Lat1*24)))*COS(RADIANS(90-(Lat2*24)))+SIN(RADIANS(90-(Lat1*24)))*SIN(RADIANS(90-(Lat2*24)))*COS(RADIANS(24*(Long1-Long2))))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distance between two sets of coordinates. 2
Distance between two sets of coordinates... update 3
Minimum Distance Calculation using Array and Geographical Coordinates 1
Calculating distance with radians 11
Help: Javascript to Excel VBA? 3
Distance Calculations between 2 Lat/Lon Coordinates 0
Cure my array headache! 7
Module Challenged Using Lat/Long Coordinates 9

Top