Acos & Asin substitute in Access

How can I calculate track & distance & wind vectors in Access. 开发者_如何学运维Many thanks

Fortunately you have Arctan in Access, so you can use the fact that if x = sin(y) then tan(y) = x/sqrt(1-x^2). In access:

 Const PI As Double = 3.14159265359
 aSin = Atn(val / Sqr(1 - val * val))
 aCos = PI / 2 - aSin

Hope this helps.