chart average monthly completion time

  • Thread starter Thread starter RLD
  • Start date Start date
R

RLD

I have a query that lists individual completion times in
months. How do I turn this data into a chart of average
completion time per month?

Thanks in advance.
 
Select MonthField, Average(CompletionTime) from tblTimes Group By
MonthField.

The Group By clause with the Average Aggregation will get the data you need.
The charting's a snap from there.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top