New Entries Added Almost Daily!
Click here to get on our Mailing List

Log

Using the Log Function

In this tutorial you will learn how to use the Log Function.

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

	SELECT Log(0);
	

In a Form you could set the Default Value of a Textbox to

	=Log(0)
	

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)
	End Sub
	

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