Hello,
I'm using Access 2000 and I'm trying to use the natural logarithm function
( ln ) in one of my modules but one doesn't exist.
Does anyone know or have a function that uses the existing Math.log/exp
functions to get the equivalent ln function?
Thanks.
Ken Snell [MVP] - 02 Mar 2005 17:19 GMT
VBA's Log function is the natural logarithm.
From ACCESS Help File:
Log Function
Returns a Double specifying the natural logarithm of a number.
Syntax
Log(number)
The required number argument is a Double or any valid numeric expression
greater than zero.
Remarks
The natural logarithm is the logarithm to the base e. The constant e is
approximately 2.718282.
You can calculate base-n logarithms for any number x by dividing the
natural logarithm of x by the natural logarithm of n as follows:
Logn(x) = Log(x) / Log(n)
The following example illustrates a custom Function that calculates
base-10 logarithms:
Static Function Log10(X)
Log10 = Log(X) / Log(10#)
End Function

Signature
Ken Snell
<MS ACCESS MVP>
> Hello,
>
[quoted text clipped - 5 lines]
>
> Thanks.