Abs(<number>) 
Returns the absolute value of <number>.

Cos(<number>)

Returns the cosine of <number> radians. See
Sin
and
Tan

e

Access does not have the value of e built in. Use
Exp(1)
to calculate e raised to the power of 1 or just define
2.718281828459 as a constant.

Exp(<number>)

Returns
e^<number>.
See
Log

Fix(<number>)

Returns the whole number between <number> and zero. Identical
to
Int
for positive numbers. Be careful with negative numbers.

Int(<number>)

Returns the nearest whole number less than <number>. Identical
to
Fix
for positive numbers.

Log(<number>)

Returns the natural (base
e
)
logaritm of <number>.
See
Exp

Pi

Access VBA does not have the value of pi built in. Use
3.1415926536 or however many digits you require.

Rnd()

Returns a
random
number. Use Randomize() to control the random number generator.

Sgn(<number>)

Returns 1, 0, or 1 when <number> is positive, zero, or
negative.

Sin(<number>)

Returns the sine of <number> radians. See
Cos
and
Tan

Sqr(<number>)

Returns the square root of <number>. Generates a runtime error
if <number> is negative.

Tan(<number>)

Returns the tangent of <number> radians. Generates a runtime
error if <number> is
Pi
/4.
See
Cos
and
Tan
