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
 
Top