Calculating Moving Average For Previous 12 Records

[Wayne Aprato]

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.

[Tom Wickerath]

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
news:4d**************************@posting.google.c om...

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.

[Wayne Aprato]

"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
news:4d**************************@posting.google.c om...

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.

Thanks Tom. No, I hadn't seen this article. I've tried the example
and it works well. I should now be able to modify it to my specific
application.

Regards.