If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Log10 function
In Access 2000 there was a Log10 function, this seems to
have disapeared in the 2002 version. The Log function in 2002 returns the Natural Log. Does anyone know how to do a Log10 in 2002? Thanks, Andy |
#2
|
|||
|
|||
Log10 function
HI Andy,
You can get the log10 of a number like this: Ln(somenumber)/ln(10) In general: x = number y = base you want to use Logy(x) = ln(x)/ln(y) Well, I just looked in Help and found this: 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) The following example illustrates a custom Function that calculates base-10 logarithms: Static Function Log10(X) Log10 = Log(X) / Log(10#) End Function HTHDan Artuso, MVP "Andy" wrote in message ... In Access 2000 there was a Log10 function, this seems to have disapeared in the 2002 version. The Log function in 2002 returns the Natural Log. Does anyone know how to do a Log10 in 2002? Thanks, Andy |
Thread Tools | |
Display Modes | |
|
|