Calculate logarithm base 10

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?
 
A

Andrew Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top