LN() function

[vipersmind]

Can some please tell me if there is an equivalent of the excel LN() function in access.

I have tried to find it all over the web and beyond and cannot

I dont mind if there is a long winded work around for this function.

I am using it in a query and it shows unrecognised function
but for some reason shows in the access help as below

LN
Returns the natural logarithm of a number.

Syntax

LN(number)

Number is the positive real number whose natural logarithm you want.

Thanks for your help
Cress

 

[vipersmind]

answered my own question

LN() =LOG()

natural log in excel is the same as log in access

who knew??

anyways this might help some else or just make me look silly either way its being posted.

Cheers.