Results 1 to 2 of 2

Thread: Running Sum

  1. #1
    Join Date
    Oct 2011
    Posts
    1

    Unanswered: Running Sum

    How to make a running sum in a query?

    Table Look like:
    ID quantity
    1 10
    2 15
    3 30


    J would like that a report look's like:
    ID quantity running sum
    1 10 10
    2 15 25
    3 30 55

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi,

    an excellent opportunity to write a stored procedure, that you could invoke as
    select running_sum( quantity ) from yourtable

Posting Permissions

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