472,353 Members | 1,200 Online

Calculating Moving Average For Previous 12 Records

I've read most, if not all, of the posts on moving average and still
can't find a simple solution to my problem (if a simple solution
exists!) I have a table with 2 fields: Hours and Injuries. I have a
query based on this table which shows these 2 fields and calculates a
third field: Frequency Rate, based on a formula which uses the Hours
and Injuries fields.

Is there a simple way of A: using yet another calculated field in the
query (or yet another query based on this one) to average the last 12
values of Frequency Rate for any given record to give a 12 month
moving average?

or B: Achieve the same end by performing a calculation in a text box
of a form based on this query?

Any help would be greatly appreciated.
Nov 12 '05 #1
2 13476
Hi Wayne,

Have you found this sample on the Microsoft KB and tried it out yet?

ACC2000: How to Compute Moving Averages in Visual Basic for Applications
http://support.microsoft.com/?id=210138
Tom

___________________________________________

"Wayne Aprato" <cq*******@volcanomail.com> wrote in message

I've read most, if not all, of the posts on moving average and still
can't find a simple solution to my problem (if a simple solution
exists!) I have a table with 2 fields: Hours and Injuries. I have a
query based on this table which shows these 2 fields and calculates a
third field: Frequency Rate, based on a formula which uses the Hours
and Injuries fields.

Is there a simple way of A: using yet another calculated field in the
query (or yet another query based on this one) to average the last 12
values of Frequency Rate for any given record to give a 12 month
moving average?

or B: Achieve the same end by performing a calculation in a text box
of a form based on this query?

Any help would be greatly appreciated.
Nov 12 '05 #2
"Tom Wickerath" <AO***********************@comcast.net> wrote in message news:<EM********************@comcast.com>...
Hi Wayne,

Have you found this sample on the Microsoft KB and tried it out yet?

ACC2000: How to Compute Moving Averages in Visual Basic for Applications
http://support.microsoft.com/?id=210138
Tom

___________________________________________

"Wayne Aprato" <cq*******@volcanomail.com> wrote in message

I've read most, if not all, of the posts on moving average and still
can't find a simple solution to my problem (if a simple solution
exists!) I have a table with 2 fields: Hours and Injuries. I have a
query based on this table which shows these 2 fields and calculates a
third field: Frequency Rate, based on a formula which uses the Hours
and Injuries fields.

Is there a simple way of A: using yet another calculated field in the
query (or yet another query based on this one) to average the last 12
values of Frequency Rate for any given record to give a 12 month
moving average?

or B: Achieve the same end by performing a calculation in a text box
of a form based on this query?

Any help would be greatly appreciated.

and it works well. I should now be able to modify it to my specific
application.

Regards.
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.