log function

R

rabald68

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top