Function Undefined "ATAN" in expression

K

KevinJ

can anyone tell me what the definition for ATAN is so i may be able to define
it at the modular level.
thanks
 
R

Roger Carlson

FROM Access 97 help:
ATAN:

The Atn function takes the ratio of two sides of a right triangle (number)
and returns the corresponding angle in radians. The ratio is the length of
the side opposite the angle divided by the length of the side adjacent to
the angle.

The range of the result is -pi/2 to pi/2 radians.

To convert degrees to radians, multiply degrees by pi/180. To convert
radians to degrees, multiply radians by 180/pi.

Note Atn is the inverse trigonometric function of Tan, which takes an
angle as its argument and returns the ratio of two sides of a right
triangle. Do not confuse Atn with the cotangent, which is the simple inverse
of a tangent (1/tangent).

---End Help---

Atn() is the built-in Access equivalent of ATAN, so use that instead of
ATAN.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
K

KevinJ

i feel stupid, i was under the impression that "atn" was something entirely
different from "ATAN", thanks again. i also went ahead and subscribed to the
access-l group at peach.ease.
kevin
 
K

KevinJ

hey roger, could you help me define "mod"? i noticed that you often
reference access 97 help for related questions, does microsoft make that
available online?
kevin
 
R

Roger Carlson

If you are referring to "modulus", that is dividing two numbers, but
returning just the remainder, it is a built-in Access operator.
Syntax:
result = number1 Mod number2
The modulus, or remainder, operator divides number1 by number2 (rounding
floating-point numbers to integers) and returns only the remainder as
result. For example, in the following expression, A (result) equals 5.
A = 19 Mod 6.7

And, yes, this example is from Access 97 Help. I keep Access 97 for just
this reason. I don't know of any other way to get it. You might be able to
find a used copy of Access 97 on Ebay or Amazon or some other on-line
auction.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Top