K
Kathy Franklin
In Acccess 2003: I want to average individually 3 different payments fields
by account, by year in a query in order to create a report based on it.
During the current year some periods are of course zero-length strings
because they haven't happened yet. When I try to average the payments the
zero-length strings are counted as zeroes and skew the average (i.e., a
quarterly account with two payments to date, as appropriate, is averaged over
four quarters because the no-entry quarters are included in the calculation).
I want an intentional zero payment to be counted, but not a blank.
by account, by year in a query in order to create a report based on it.
During the current year some periods are of course zero-length strings
because they haven't happened yet. When I try to average the payments the
zero-length strings are counted as zeroes and skew the average (i.e., a
quarterly account with two payments to date, as appropriate, is averaged over
four quarters because the no-entry quarters are included in the calculation).
I want an intentional zero payment to be counted, but not a blank.