Running balance and balance b/f

[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

 

[Allen Browne]

Use the Running Sum property of the text box on the report.

 

[George]

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" έγγÏαψε:

 

[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.