Running Balance

[paulaziz]

I have a table that stores transactions for income and expenditure. the fields of the table is shown below transid, accountcredited, accountdebited, date, amount. Every transaction has double entry; it debits one account and credit another. The accountcredited and accountdebited are linked to accounts table(the fields for accounts table are accid, accountno, balance) The problem is I cannot figure out sql statement generate running balance Thanks in advance

[Mycroft Holmes]

Try a search [^] this question has been answered so many times before.

Never underestimate the power of human stupidity RAH

[Blue_Boy]

I guess you have to use SUM and GROUP BY, by the way your question is not enough clear.

---

I Love T-SQL "VB.NET is developed with C#.NET" If my post helps you kindly save my time by voting my post.