title: How to sum up previous rows value with current row in ms access query?
body: <p>The input is as follows:</p>
  
  <pre><code>name  |  qty  
  -------------
   A    |   10   
   B    |   20  
   C    |   20
  </code></pre>
  
  <p>The output should be:</p>
  
  <pre><code>Name    |  qty
  ---------------
   A      |   10
   B      |   30
   C      |   50
  </code></pre>
  
  <p>=>for first row the score should come as it is..</p>
  
  <p>=>for second row it should be the sum of previous row and the current row.. </p>
  
  <p>=>for third row it should be the sum of the previous 2 rows and the current row..</p>
  
  <p>How to write a ms access query for this one..
  Help me out..</p>
  
  <p>Thanks in advance...</p>