Running balance and balance b/f

  • Thread starter Thread starter George
  • Start date Start date
G

George

Dear friends,

I am in the process of developing my Bank Accounts database.

I have created a form to select the account and also the period of the
statement (FromDate – ToDate).

Using queries I can find the total deposits and total withdraw amounts
before the FromDate in order to show on the report the Balance brought
forward.

Now, my big problem is how to create the running balance for each
transaction, shown on the report.

e.g. I select the period (on the form) 1/1/2008 -1/10/2008

Balance b/f : 100 (all transactions before 1/1/2008

1/1/2008 – deposit 50 – should show the Balance 150
1/2/2008 – deposit 100 – should show the Balance 250
1/2/2008 – withdraw 25 – should show the Balance 225

Any help will be highly appreciated,

Thanking you in advance

GeorgeCY
 
Thanks a lot Allen for your prompt reply.

Actually I have used the Running Sum without any success, because I need to
take into consideration the previous amount - balance brought forward (all
transactions previous to the DateFrom) and then continue to give me the
running sum.

Any ideas?

Ο χÏήστης "Allen Browne" έγγÏαψε:
 
You could use a text box with properties something like this:
Control Source =Nz([Credit],0) - Nz([Debit],0)
Running Sum Over Group
Format Currency
Visible No
Name txtBalanceRS

Then another text box with Control Source of:
=[OpeningBalance] + [txtBalanceRS]

Naturally you will need to substitute your own field names etc, but that's
the idea.
 
Back
Top