View Single Post
Old July 30th, 2007, 10:26 PM posted to microsoft.public.access.reports
Dan Test
external usenet poster
Posts: 1
Default In Access what expression do I use to average a field ignoring 0?

I have a report that calculates the average of a requested field. The average
is not correct due to "0" values in some of the records. What expression do I
use in the Control Source to ignore the 0 entries? I tried to adapt the one I
use in Excel but did not get the results I was looking for.
Thanks for the help.