Using the Log Function
In this tutorial you will learn how to use the Log Function.
The Log function returns a Double specifying the natural logarithm of a number.
=Log( number )
number any valid number expression
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)
In this example we will use 1.
The result is 0.
The results using a Query would be
In a Form you could set the Default Value of a Textbox to
In a Form add a TEXTBOX control and rename it "txtLog", then you could add the following in the Load Event.
Private Sub Form_Load()
txtLog = Log(0)
Access Expert 26
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips