Using the Exp Function
In this tutorial you will learn how to use the Exp Function.
The Exp function returns a Double specifying e (the base of natural logarithms) raised to a power.
=Exp( number )
number any valid number expression
If the value of number exceeds 709.782712893, an error occurs. The constant e is approximately 2.718282.
The Exp function complements the action of the Log function and is sometimes referred to as the antilogarithm.
In this example we will use 1.
The result is 2.71828182845905.
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 "txtExp", then you could add the following in the Load Event.
Private Sub Form_Load()
txtExp = Exp(1)
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