SUMMARY Formula for All Months in Access report Grouped by Month at the End of Report

[chrisjack001]

I need help with the formula or step in a report in Access to get Summary for All Months in the report Grouped by Month at the end of the report before the Grand Total as seen below. Thanks for your help.

Example
Account 1 Jan 2009 $1500


Feb 2009 $800
Account 2 Jan 2010 $5000
Feb 2010 $200
SUMMARY OF JAN $6500
SUMMARY OF FEB $1000
GRAND TOTAL

[NTC]

I will guess that although you post only gives 2 examples you want to do 12. In this case I would look to do it in a standalone AggregateQuery....and then insert that as a subreport into the report's footer.

[weekend00]

subreport is good.