Results 1 to 2 of 2

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

  1. #1
    Join Date
    Aug 2010
    Posts
    6

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

    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

  2. #2
    Join Date
    Mar 2006
    Location
    Oklahoma City, OK
    Posts
    184
    Boyd Trimmell aka HiTech Coach
    Microsoft MVP - Access Expert
    [SIGPIC][/SIGPIC]
    Office Programming 25+ years as a Software Developer specializing in:
    Business Process Management
    Accounting/Inventory Control
    Customer Relations Management (CRM)
    Electronic Data Interchange (EDI)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •