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