ARCCosine Function in Access

[Larry]

I tried to use ARCCosine function in Microsoft Access but
it's not recognizing the format. I used ACOS and ARCOS. I
just found out that there is no such function like this in
Access. SIN, COSINE and ATAN are all working but not the
ACOS or ARCOS. I need your help on this one please.

Thank you in advance.
Larry

 

[George Hester]

here try this:

http://functions.wolfram.com/ElementaryFunctions/ArcCos/27/ShowAll.html

and click show all. I'm sure you'll find an equivalent representation in there. My math is sort of rusty or I would do it here. Sorry.

 

[George Hester]

OK thnaks. In accepted Mathematical notation it is incorrect and I don't believe the site was directed towards Visual Basic.

 

[david epsom dot com dot au]

Actually, I have no idea if the formula is correct - I just meant
about the log/ln stuff. For ArcCos I would use

ArcCos = Atn(-X / Sqr(-X * X + 1)) + 2 * Atn(1)

(As shown in VBA help if you can find it). I think the formula
for Atn involves natural logs, but Atn is already a VB intrinsic
function anyway.

(david)


OK thnaks. In accepted Mathematical notation it is incorrect and I don't
believe the site was directed towards Visual Basic.

 

[George Hester]

Yeah that one is better. There is an even better one at the place using a form of inverse sine to give the arctan. I really should be able to show it here and I'm kicking myself because I'm so rusty on this stuff.
here:

arccos(z) = pi/2 - arcsin(z) z is in radians.and abs(z)<=1