log function

R

robbie

Hi
I need to calculate a log of a number in Access,
easy enough in excel but I'm getting a different answer in access,

my [tvc] number is 60
in excel the log is showing as 1.778* =log(60)
but in access log([tvc]) is giving me 4.09.

help please.
 
J

John Spencer

The access Log function returns the natural log; Unless you specify
otherwise, Excel Log function returns the log base 10. If you want the
natural log in Excel use the LN function.

To get the base 10 log in Access, you need a formula such as the following.
Natural Log of your number divided by the Natural Log of the base

Log(60)/Log(10) --> 1.77815125038364
 
R

robbie

thanks very much.

John Spencer said:
The access Log function returns the natural log; Unless you specify
otherwise, Excel Log function returns the log base 10. If you want the
natural log in Excel use the LN function.

To get the base 10 log in Access, you need a formula such as the following.
Natural Log of your number divided by the Natural Log of the base

Log(60)/Log(10) --> 1.77815125038364



robbie said:
Hi
I need to calculate a log of a number in Access,
easy enough in excel but I'm getting a different answer in access,

my [tvc] number is 60
in excel the log is showing as 1.778* =log(60)
but in access log([tvc]) is giving me 4.09.

help please.
Click to expand...
Click to expand...
 
Top