Averages For Certain Records

  • Thread starter Thread starter Michael Comtois
  • Start date Start date
M

Michael Comtois

I am using Access 2002. What I want to be able to do is
have only certain rows on a report averaged at the end
based on the type. For instance, each record has a type
D, N, or Other, which is a column on the report, and I
want to be able to have "Average for Type D:" and Average
a different column called TurnAround for that type. Any
ideas? Help would be greatly appreciated.

Michael
 
I would create a query similar to your report's record source. Make it into
a totals query and group by Type and average your other field. Create a
subreport based on this query and add it to the bottom of your main report.
 
Back
Top