J
Jugador5
I'm trying to calculate an average turnover off of a query that
automatically calculates one month's turnover. But, I must average this
in order give meaningful data for multiple month spreads, but can't get
a function to work.
I made a query that counts the number of months in the report (chosen
from a combo box on a form) and sums the turnover for each position.
But, since two months' data equals one month turnover, I need to
subtract one off of that count in order to divide the sum of the
percentages by it.
I'm a newbie, so can anyone help me figure out how to take one off of
that automatic count?
Thanks!
automatically calculates one month's turnover. But, I must average this
in order give meaningful data for multiple month spreads, but can't get
a function to work.
I made a query that counts the number of months in the report (chosen
from a combo box on a form) and sums the turnover for each position.
But, since two months' data equals one month turnover, I need to
subtract one off of that count in order to divide the sum of the
percentages by it.
I'm a newbie, so can anyone help me figure out how to take one off of
that automatic count?
Thanks!