Average percent by month query

[jtmott]

Hi I have a table that has a date field formatted to mm/dd/yyyy (01/01/2013). it has another field that shows percent of an order shipped on time.
the query I'm trying to create would show the average percent by month.


Example:
January 80%
February 90%
March 100%

My big problem stims from trying to group by month.
I would appreciate any help I can get.
Thanks

[June7]

Try:

SELECT Format([datefield],"YYYY/MM") AS YrMo, Avg([percentfield]) GROUP BY Format([datefield],"YYYY/MM");

[jtmott]

Thank you it worked just like I needed.