Dear Sir,

Below shown table contained daily CASH BOOK entries in my Accounting application with Date, Details, Debit, Credit....

the Balance Column I have to update end of the month because middle of the month Accounts Clerks may change some figures or corrections.

Date....Desc...............Debit...........Credit........Balance
1/1......Cash Balance.....................................5000
1/1......Sales..............2000...........................
2/1......Purchase.............................2000.......
3/1......Sales..............3000...........................
4/1......Rent...................................1000.......

the above transaction continuing upto 31/1/2011. Now I want to update all the rows at a time for complete month like this.
Cash Balance + Debit - Credit = Balance

I'm using Visual Basic 2010 & Database SQLServer, I hope if you can give SQL command to me then I can complete my project successfully.

Please help me to solve it with written sample code.