Report running ballance

[Jim/Chris]

Here is a post from the great Allen Browne
Text boxes on a report have a Running Sum property.

Add a text box to the report, and give it these properties:
Control Source Debit
Running Sum Over Group
Name txtDebitRS
Visible No

Add another one bound to the Credit field, with Running Sum
turned on, and
name it (say) txtCreditRS.

You can now set the Control Source for your Balance text
box to:
=[txtCreditRS] - [txtDebitRS]

Allen Browne - Microsoft MVP. Perth, Western Australia.


Jim

 

[XeniaEagle]

Thanks "Jim/Chris"
I will try that later tonight. and get back to you
Thanks for the prompt reply
Roger

Here is a post from the great Allen Browne
Text boxes on a report have a Running Sum property.

Add a text box to the report, and give it these properties:
Control Source Debit
Running Sum Over Group
Name txtDebitRS
Visible No

Add another one bound to the Credit field, with Running Sum
turned on, and
name it (say) txtCreditRS.

You can now set the Control Source for your Balance text
box to:
=[txtCreditRS] - [txtDebitRS]

Allen Browne - Microsoft MVP. Perth, Western Australia.


Jim

-----Original Message-----
I am making a check book which is printed out each week, I have a income
field and a expense field. and a ballance field. the control is a querry
with a beginning
and a end date. I cannot get the ballance field to show the running
ballance. I have a identical querry without the begin and end date, but the
report will not let
me pull the running ballance from it.
What am I doing wrong, my access book doesn't have the answer.
Thanks for any help
Roger
.

 

[XeniaEagle]

Jim
I must be doing something wrong.
That returns the difference between the 2 fields for the
dates entered. I need a ballance since day 1
Say I have a starting ballance of $5000.00 starting out last week
I write 4 checks for total of $1000.00 and I have income of
$500.00 My new ballance would be $4500.00
I want to print out the check book for this week showing the
4 checks and the income, with the ballance of 4500
Thanks for the help
Roger

Here is a post from the great Allen Browne
Text boxes on a report have a Running Sum property.

Add a text box to the report, and give it these properties:
Control Source Debit
Running Sum Over Group
Name txtDebitRS
Visible No

Add another one bound to the Credit field, with Running Sum
turned on, and
name it (say) txtCreditRS.

You can now set the Control Source for your Balance text
box to:
=[txtCreditRS] - [txtDebitRS]

Allen Browne - Microsoft MVP. Perth, Western Australia.


Jim

-----Original Message-----
I am making a check book which is printed out each week, I have a income
field and a expense field. and a ballance field. the control is a querry
with a beginning
and a end date. I cannot get the ballance field to show the running
ballance. I have a identical querry without the begin and end date, but the
report will not let
me pull the running ballance from it.
What am I doing wrong, my access book doesn't have the answer.
Thanks for any help
Roger
.