ARCCosine Function in Access

  • Thread starter Thread starter Larry
  • Start date Start date
L

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
 
OK thnaks. In accepted Mathematical notation it is incorrect and I don't believe the site was directed towards Visual Basic.
 
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.
 
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
 
Back
Top