SUM OF THE LINES

Hey,

take a look at the below. I need to sum the real balance of a line with the credit with the line above, or, n + 1. I don't wanna to have to walk across the lines to do the sum. Any idea of how to do that in a easier and better way? I tried using T-SQL, but I couldn't figure out how to do a reference to the next line on the SQL without moving the cursor.



Date
Reference
Description
Debit
Credit
Real Balance
Bank Balance
 
Grp
Action




$0.00
$6,000.00
$86,814.27

*
 
  




$0.00
$4,000.00
$90,814.27



  




$0.00
$666.00
$91,480.27

*


Thank you!