I'm new to Access and trying to figure out how to calculate averages for a report that already contains averages.

The report uses a TRANSFORM statement to display the monthly averages for each region/office/order type as follows:

"TRANSFORM Avg(Work_Days(ORDERS.[DATE RECEIVED],ORDERS.[DATE COMPLETED])) AS WorkDays" _
& " SELECT [Region/Office].Region, [Client List].Office, [Type of Order].[Type of Order]" _
& " FROM ORDERS, [Region/Office], [Client List], [Type of Order]" _
& " WHERE ORDERS.CLIENT = [Client List].[Client ID]" _
& " AND [Client List].Office = [Region/Office].Office AND Orders.[DATE RECEIVED] Is Not Null" _
& " AND Orders.[DATE COMPLETED] Is Not Null AND Orders.REVISION = 0 AND ((ORDERS.TYPE)=[Type of Order].[code]) AND " & whereCond _
& " GROUP BY [Region/Office].Region, [Client List].Office, [Type of Order].[Type of Order]" _
& " ORDER BY [Region/Office].Region, [Client List].Office, [Type of Order].[Type of Order]" _
& " PIVOT Format(ORDERS.[DATE COMPLETED],'mmm') In ('Jan','Feb','Mar','Apr','May','Jun','Jul','Aug',' Sep','Oct','Nov','Dec');"

Then, the report displays the averages of the averages at the bottom by calculating [mmm]/Sum[mmm]. However, the user doesn't want to see the average of the averages. They want to see the average of all entries within the region/office. Any ideas on how to get this?

Thanks,
Mike Fameree