Obtain the MAX values on a monthly basis

[rajmns]

Hello Gurus,



I have a table with data on daily basis. I want to create a report that gives me data on daily basis but breaks every month and gives me the max value for each month. Is it possible to achieve that using Queries?

Your feedback is appreciated.

Thank you.

[pbaldy]

This should give you the monthly max:

SELECT Format(DateFieldName, "yyyymm") As TheMonth, Max(DataFieldName) As MaxData
FROM TableName
GROUP BY Format(DateFieldName, "yyyymm")