How do I setup Log10 in a calc field in i access sheet

[Ole]

I intend to make a calculation in one sheet and plan to use a clac in the
contol source but only get error. The formula is set up like
=813,2/(6,82973-(Log10(3,3/0,001333221913311))-248). Can anybody tell me the
best way of solving this

 

[Tom Wickerath]

Hi Ole,

The Visual Basic Help file shows the following for the Log function:

Log Function
Returns a Double specifying the natural logarithm of a number.

Syntax
Log(number)

The required number argument is a Double or any valid numeric expression
greater than zero.

Remarks

The natural logarithm is the logarithm to the base e. The constant e is
approximately 2.718282.

You can calculate base-n logarithms for any number x by dividing the natural
logarithm of x by the natural logarithm of n as follows:

Logn(x) = Log(x) / Log(n)

The following example illustrates a custom Function that calculates base-10
logarithms:

Static Function Log10(X)
Log10 = Log(X) / Log(10#)
End Function
______________________________________________

So, I think you will need something like this:

=813,2/(6,82973-(Log(3,3/0,001333221913311)/2,30258509299405)-248)

where the Log(10) = 2.30258509299405



Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Van T. Dinh]

Log(Base 10) of number R = Log (base e) R / Log (Base e) 10

Log (Base e), i.e. natural Log is available in VBA - Log().