Access 2007-2019 Access 2000-2003 Access Seminars TechHelp Support Tips & Tricks Access Forum Course Index Topic Glossary Insider Circle

 Home   News   Courses   Seminars   Templates   Help   TechHelp   Forums   Order   Contact   Logon More... What's New? Tips & Tricks Access Index Access Tips Excel Index Excel Tips Waiting List

 Access    Excel    Word    Windows    HTML

# Log

## 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.

Query

The results using a Query would be

```	SELECT Log(0);
```

FORM

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

```	=Log(0)
```
VBA

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
```

Courses Search