Calculate logarithm base 10

  • Thread starter Thread starter 2806
  • Start date Start date
2

2806

I need to calculate a log (base 10) on an access form. I
have tried both the expression builder and vba. I can
calucalate all of the natural logs I want using log
function but I cannot get either expression builder or vba
to calculate the log 10. Any suggestions?
 
Divide the natural log by the natural log of 10.

eg:

Public Function Log10(dblNumber as Double) As Double
Log10 = Log(dblNumber)/Log(10)
End Function
 
Back
Top