Search results

Also, I am only trying to find answers to my question in detail for better understanding. So far, the people within this forum that are responding are providing vague answers to detailed questions, or, are providing information that i do not understand yet therefore i ask additional questions...

Jeeze ! I was un aware that COUNT and AVERAGE were both one and the same.

I am trying to count the number of unbound cells that have a value greater or less than zero. The cells names are: Dif1, Dif2, Dif3 and Dif4. I am also trying to sum those same cells and then devide the count that is greater than zero in the Sum. This would create the average without being...

Yes, indeed I am a newbie to creating functions within Access. Would you be so kind and explain the details in what you have previously mentioned? It would be greatly appreciated. Thanks Again

Yes i did double post as I was uncertain as to which category this should be placed. My appologies.

I am trying to Average values in four unbound cells(named: Dif1, Dif2, Dif3 and Dif4) on a form. Some cells will have zero values so I only want to average the cells that have a value greater than zero. Any guidence would be appreciated. Best Regards

I am trying to Average values in four unbound cells(named: Dif1, Dif2, Dif3 and Dif4). Some cells will have zero values so I only want to average the cells that have a value greater than zero. Any guidence would be appreciated. Best Regards