C
Chuck W
Hello,
I have a table called tblMedError that has three fields. Month,
MedErrorActual and MedErrorTarget. A user inputs the actual and taget values
via a form. I want to run a query that lists all of these fields along with a
calculated field called MedErrorAvg. This would be a rolling 12 month
average the MedErrorActual field. The output in my query that I want for my
report would be:
Month MedErrorActual MedErrorTarget MedErrorAvg
3/1/09 10 5 7.3
4/1/09 12 5 7.6
5/1/09 11 5 8.2
6/1/09 9 5 8.1
Can someone help?
Thanks,
I have a table called tblMedError that has three fields. Month,
MedErrorActual and MedErrorTarget. A user inputs the actual and taget values
via a form. I want to run a query that lists all of these fields along with a
calculated field called MedErrorAvg. This would be a rolling 12 month
average the MedErrorActual field. The output in my query that I want for my
report would be:
Month MedErrorActual MedErrorTarget MedErrorAvg
3/1/09 10 5 7.3
4/1/09 12 5 7.6
5/1/09 11 5 8.2
6/1/09 9 5 8.1
Can someone help?
Thanks,