Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012
    Posts
    85

    Unanswered: Running sum help!

    I was able to get a running some to work, but i cant seem to get it to restart for each category... for example this is what I have...

    ID Name Return Run. Sum
    1 aaa 0.1 0.1
    2 aaa 0.2 0.3
    3 aaa 0.3 0.6
    4 aaa 0.1 0.7
    5 bbb 0.5 1.2
    6 bbb 0.4 1.6
    7 bbb 0.1 1.7
    8 bbb 0.3 2
    9 bbb 0.2 2.2

    How do i get it to start over at bbb???
    Here is the code in access 2010:
    Format(1000+(DSum("Return","Monthly Performance Dates","[ID]<=" & [ID] & "")*1000),"00.00")

    THANKS

  2. #2
    Join Date
    Jun 2012
    Posts
    85
    my apologizes im in the wrong area!

Posting Permissions

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