Average a field for all records in report

[pbuethe]

The query the report is based on is as follows:

Columns are:
Group by RateCodeType
Count of CaseNbr
Avg, StdDev, Min, and Max of LOS

RateCodeType, CaseNbr, and LOS are all fields in tblRetroVolumes.

I have text boxes calculating the Total Cases, Minimum LOS, and Maximum LOS for all the records in the Report Footer. I cannot figure out how to get the Average and Standard Deviation for all the records. I don't think it will work to average the averages, etc.

Thanks for any help.

 

[pbuethe]

OK, I got the answer when I was searching the forum for the answer to a different question!

I created another query with columns for the Avg and StDev of the LOS. Then created two textboxes in the Report Footer. I put a DLookup to one of the columns of the query in the control source of each text box.

Problem solved! Thanks again for this forum!