Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Oct 2002
    Posts
    25
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Running Sum (XPSP1)

    In report had:

    Sum([Grand Total]) property set to running sum over group.

    Now I am using:

    =Format([Beginning Date],"mmmm-yyyy") & " to " & Format([Ending Date],"mmmm-yyyy") & " to date total: " & Sum([Grand Total])

    to return e.g.:

    April-2002 to June-2002 to date total: 125

    How can I set Sum([Grand Total]) to running sum over group within the expression?

    TIA.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Running Sum (XPSP1)

    You can't. A running sum is a property of a textbox on a report, not something you can apply within the controlsource. There are also problems trying to do calculations on calculated values, but you can reference a textbox that contains a calculated value in your expression.
    Charlotte

Posting Permissions

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