AnsweredAssumed Answered

Showing Total Balance of Each Account

Question asked by ShaikhAtta on May 4, 2012
Latest reply on May 4, 2012 by philmodjunk

Title

Showing Total Balance of Each Account

Post

Hello All,

               I have the 2 below tables with some sample data and the relationship of Accounts::AccountID  with Transactions::AccountID

 

Table 1: Accounts

Account ID          Name

001                      John

002                     Abraham

003                     Kate

 

Table 2 : Transactions

 

Account ID          Name             Credit               Debit          RunningBalance

002                     Abraham          500                     0               500

003                     Kate                    0                  100             400

002                     Abraham              0                  200             200

001                     John               1000                     0             1200

 

 

Now this is what I want, the list of each total account like this in a report printable format.

 

Account ID       Name               TotalCredit           TotalDebit            TotalBalance

001                     John                     1000                           0                    1000

002                     Abraham                500                         200                    300

003                      Kate                        0                           100                   100

 

 

Thanks for the support in advance

Outcomes