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

    Unanswered: Please help quick!

    hey,
    Ive really been struggling with this. I was able to calculate running sum for my query. but I need it to break up. eg.

    Fund Return Total
    aaaaa .2 .2
    aaaaa .1 .3
    aaaaa .1 .4
    bbbbb .2 .2 This is where i need it to start again. I cant seem to figure it out
    bbbbb .3 .5
    bbbbb .1 .6

    I have an id column before fund. this is what my total expression is:
    Format(1000+(DSum("Return","Monthly Performance Dates","[ID]<=" & [ID] & "")*1000),"00.00") .... note, Monthly Performance Dates is the table
    PLEASE HELP Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    haven't got a clue what you are on about
    where do you expect to tuse this result.. in a form, report, both

    the runnign sum could be doen using the sum, or average and a group by clause
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2012
    Posts
    85
    Im using it in a report. I am needing help on getting the running sum to restart for each fund. IE adds up all the A's and adds up all the B's. but i need it to add up as it goes a long. the rows as there is another column year. and it splits up the returns given the years. etc.. I think its much easier to do then what ive been doing. but for some reason i cant get it

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if its used in a report then use the reports grouping functions
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jun 2012
    Posts
    85
    I forgot to mention im am using it in the Pivot chart view to creat an area graph. Thanks

  6. #6
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Answered accidentally in a duplicate thread:

    http://www.dbforums.com/microsoft-ac...-sum-help.html
    Paul

Posting Permissions

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