Report-Chart Wizard-AVG instead of SUM

[Dan Dan the OTTR Man]

I have a chart report based on a query where the values are
percentages. I would like the chart to display average percentages by
month instead of the sum of the percentages by month. Does anyone
know how I can do this? Any help is appreceated.

 

[Arvin Meyer [MVP]]

Change the Total line where it says Sum, to Avg.

 

[Dan Dan the OTTR Man]

Change the Total line where it says Sum, to Avg.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com





- Show quoted text -

That was incredibly simple. Thanks Arvin!