Summarising daily data into monthly and graphing.
I have a section of my database that allows users to enter in the daily waste of DVD cases.
I'd now like to summarise my daily waste into months so it can be graphed as "waste per month"
I've tried a few different ideas but I'm struggling to find a solution.
Any help on this would be amazing!