Distance Calculations between 2 Lat/Lon Coordinates

G

Glenn

I am trying to perform distance Calculations between 2 coordinates (Lat,Lon) in Access 2000, using the formula:

d=acos(sin(lat1)*sin(lat2)+cos(lat1)*cos(lat2)*cos(lon1-lon2)

Unfortunately, I cannot find the ACOS function in Access, (althought it is available in Excel). Is there an update or add-into Access that has this function available?

or is there a work around I can use instead of using ACOS to provide the Distance result?
 

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

How to code this math 3
Will this formula work in Access (distance between Lat/Long points 0
Public Function Acos 4
Minimum Distance Calculation using Array and Geographical Coordinates 1
'Undefined function in expression' error 4
Undefined function 'ACOS' in expression 4
Distance between two sets of coordinates. 2
Distance between latitude and longitude 1

Top