Running Balance

[aziz]

Hi Folks

I have a double entry transaction table named trans which accumulates both debit and credit transactions. The structure of the table is shown below.
[accountcredited]
[accountdbited]
[amount]
[dateoccurred]

The trans table is linked to accounts(by acctdebited and acctcredited) table whose structure is shown below
[accountno]
[accountname]
[balance]; i.e the current balance each account.


I am able to calculate the current balance for each account.

My problem is how generate running balances for each account like bank transaction showing the transactions that gave each account its balance to date.

I cannot figure out how to handle this problem.


Any assistance would be greatly appreciated.

 

[Alansidman]

Here is a template I developed to use as my checkbook. You can see in the query how I do a running balance which is used as the record source for the report.