ARCCOSINE FORMULA

L

Larry

I tried to calculate the distance between two points using
latittude and longitude but it seems like Microsoft Access
will not recognize my "ArcCos" and "Acos" in the queries.

Here's my formula:
3963.1*ARCOS[SIN(A)*SIN(C)+COS(A)*COS(C)*COS(B-D)]

A=49.18722, B=123.1853, C=43.67972, D=79.625

If I take out the ARCOS
 

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

Longtitude and Latitude Question 4
SQL Query to Order by distance - my brain is fried 1
Calculating distance with radians 11
Distance calculation for lat/lon's? 5
Module Challenged Using Lat/Long Coordinates 9
Will this formula work in Access (distance between Lat/Long points 0
equation and error handling 3
ARCCosine Function in Access 4

Top