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.