ACOS

[Terry Droessler]

The arc cosine function ACOS shows up in Access 2000 help
along with other trig functions. I've been using COS and
TAN in SQL statements. I want to use ACOS in an SQL
statement to get an angle knowing the adjacent and
hypotenuse distances in a right triangle, but SQL comes
back with "Undefined function "ACOS" in expression".

Any suggestions for getting the ACOS function to work in
an SQL statement or some other workaround in SQL or ??

Thanks!

[Lynn Trapp]

ACOS() is a Worksheet function available only in Excel. Cos() and Tan() do
appear to be available in VBA. Unfortunately, Access 2000 help mixes in
Excel help with Access help.

--

Lynn Trapp
MS Access MVP
ltr...@nwidevelopers.com
www.nwidevelopers.com

"Terry Droessler" <ter...@duckcreekassociates.com> wrote in message
news:705601c20337$5d8cac20$95e62ecf@tkmsftngxs02...

[Michel Walsh]

Hi,

From the help file, under Derived Math Functions:

Inverse Cosine Arccos(X) = Atn(-X / Sqr(-X * X + 1)) + 2 * Atn(1)

Hoping it may help,
Vanderghast, Access MVP

"Terry Droessler" <ter...@duckcreekassociates.com> wrote in message
news:705601c20337$5d8cac20$95e62ecf@tkmsftngxs02...

[Tom Ellison]

Dear Lynn:

Now I'm confused. If there is an ACOS function in a DLL somewhere and you set
a reference to it, won't you be able to use it? Being both Office products
using VBA, wouldn't all the functions available for Excel be available for
Access? If so, couldn't this be treated as a references problem?

Someone would just have to find where the function is, then. Of do I have
entirely the wrong idea?

Tom Ellison
Microsoft Access MVP

[Lynn Trapp]

Tom,
I see no reason that it couldn't work by creating a reference to Excel, but
I've never tried that. Perhaps Terry will want to give that a shot or use
the function posted by Michel.

--

Lynn Trapp
MS Access MVP
ltr...@nwidevelopers.com
www.nwidevelopers.com

"Tom Ellison" <tell...@jcdoyle.com> wrote in message
news:3CEE72B7...@jcdoyle.com...