log function

[rabald68]

why do i get an "improper procedure call" when i try to average the results
of the log function in a query?

 

[Clifford Bass via AccessMonster.com]

Hi,

I would presume in your data set you have some zeroes and/or negative
numbers. Remove the summary aspect of your query so you are getting all of
the records with the Log values. Do any show #Error in the Log(columnname)
column? If so, that is your problem. Eliminate them with an appropriate
condition of columnname > 0.

Clifford Bass

 

[Daniel Pineault]

Please post your query's SQl statement so we may have a look at it and try to
help you.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.