Access: Log Function

In Access, the Log function returns the natural logarithm of a number. The natural logarithm is the logarithm to the base e. The constant e is approximately 2.718282.

The syntax for the Log function is:

Log ( number )

The argument number can be any valid numeric expression greater than zero.

Log(3.1)        returns 1,1314021115 Log(5)           returns 1,6094379124 Log(17)         returns 2,8332133441

VBA Code

Dim MyNumber MyNumber = Log(14)

This example uses the Log function to return the natural logarithm of a number. Now the MyNumber variable would contain the value 2,6390573.

SQL query

You can also use the Log function in a query.

SELECT Log([OwnerId]) AS Expr1 FROM Orders