LOG vs LOG10

[Mark Sievers]

I am trying to run a query that calculates the LOG base 10
of a value, x. When I do LOG(X), Access give me the
natural log. Access will not recognize the function LOG10
(x) or LOG(x,10). Access does not recognize LN(x) either.
Does anyone have any ideas why this is happening, how to
fix it, or how to get around it. The dataset is too large
for Excel to handle (>300,000 records).

Thanks!

 

[Brian Camire]

You might use

Log(x) / Log(10)

this is equivalent to

LOG10(x)

for x > 0.