log Function

[rhorne]

Help .... i give us !!!! anybody know correct syntax/expression for log of a number. The number i am getting in Access is twice as big as the correct number i get in excell

 

[jdraw]

see Doug Steele's post at
http://www.pcreview.co.uk/forums/do-get-natural-logarithm-access-forms-its-ln-excel-t3248049.html


Access is natural log (base e)

 

[gemma-the-husky]

eg

Sub logs()
MsgBox ("natural log of 2 = " & log(2))
MsgBox ("log base 10 of 2 = " & log(2) / log(10))
End Sub

 

[rhorne]

It works!!!! But you veterans knew it would
Thanks much, am just getting into some of this so u may see me again.