Click here to Skip to main content
15,920,513 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
I have a table AccountReceivable with these columns
ID   ReceiveDate    Ref_No   Account_Code    Account_Name            Details      Debit    Credit 

1    2013-02-19              101             Account Receivable       wama        500

2    2013-02-19              101             Account Receivable       NRA                  200

I want to get the running balance into the balance column like:-
ID  Receiveddate Ref_no Account_Code  Account_Name   Details  Debit  Credit balance

1    2013-02-19          101                         wama      500            500

2    2013-02-19          101             A           NRA              200     300
Updated 8-Apr-13 1:26am

Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900