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


Leave a Reply

Your email address will not be published.