Results 1 to 2 of 2
  1. #1
    chavez_sea is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Feb 2011
    Posts
    105

    running sum

    Dear all,
    I need some help with a query or if I need to run a report, to show the running sum of a field.

    I would be grateful for some help.



    Thanks

    Cristina

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,643
    It's easiest on a report, using the Running Sum property of a textbox. It can be done in a query, but involves either DSum() or a subquery, either of which can really hamper performance with large data sets.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. A running sum and filters
    By Marin in forum Reports
    Replies: 4
    Last Post: 07-28-2013, 02:00 PM
  2. Running queries, VIA VB, but not running in Order
    By mike02 in forum Programming
    Replies: 6
    Last Post: 06-01-2013, 07:07 AM
  3. Running log of dates
    By snowboarder234 in forum Forms
    Replies: 5
    Last Post: 08-22-2012, 02:08 PM
  4. Running Sum
    By rpgowned in forum Queries
    Replies: 2
    Last Post: 08-30-2011, 10:17 AM
  5. Running Cmd problem
    By timpepu in forum Programming
    Replies: 3
    Last Post: 04-09-2010, 10:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums