C
cru
I am trying to find easier way to calculate prior 3 mo average. Currently, I
am doing the manual calculation in Excel after importing from Access. I
would like to calculate in Access.
In the table, I want to calculate period 12/31/2009 where I need the 3mo
average of the prior 3 mo count. I wonder if there is a function that can
say for current month what is the prior 2 mo avg (counting the current period)
PERIOD COUNT 3-MO AVG
10/31/2009 1000
11/30/2009 2000
12/31/2009 3000 2000
Your help is appreciated!
Cru
am doing the manual calculation in Excel after importing from Access. I
would like to calculate in Access.
In the table, I want to calculate period 12/31/2009 where I need the 3mo
average of the prior 3 mo count. I wonder if there is a function that can
say for current month what is the prior 2 mo avg (counting the current period)
PERIOD COUNT 3-MO AVG
10/31/2009 1000
11/30/2009 2000
12/31/2009 3000 2000
Your help is appreciated!
Cru