473,695 Members | 2,483 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 13601
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*******@volc anomail.com> wrote in message
news:4d******** *************** ***@posting.goo gle.com...

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************ ***********@com cast.net> wrote in message news:<EM******* *************@c omcast.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*******@volc anomail.com> wrote in message
news:4d******** *************** ***@posting.goo gle.com...

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.