By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,889 Members | 1,373 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,889 IT Pros & Developers. It's quick & easy.

Calculating Moving Average For Previous 12 Records

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Nov 12 '05 #2

P: n/a
"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.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.