Running balances in reports

[fuzzybrain]

hi,
how do you create a running balance in an access report.
using xp on xp.
thanks.

 

[Joseph Meehan]

hi,
how do you create a running balance in an access report.
using xp on xp.
thanks.

From the Help file:

RunningSum Property

You can use the RunningSum property to calculate record-by-record or
group-by-group totals in a report. Read/write.

expression.RunningSum
expression Required. An expression that returns one of the objects in the
Applies To list.

Remarks
The RunningSum property specifies whether a text box on a report displays a
running total and lets you set the range over which values are accumulated.
For example, you can group data by month and show the sum of each month's
sales in the group footer. You can show the running sum of accumulated sales
over the entire report (sales for January in the January footer, sales for
January plus February in the February footer, and so on) by adding a text
box to the footer that shows the sum of sales and setting its RunningSum
property to Over All.

Note The RunningSum property applies only to a text box on a report.

The RunningSum property uses the following settings.

 

[fuzzybrain]

thank you Joseph,
I did do help first but i was serching for running balance.
I also tried to do a search on this site but MS is redoing
this site and search is turned off and will be for a
couple of weeks per MS.
but thanks for you help. it has pointed me in the right
direction.

 

[Joseph Meehan]

thank you Joseph,
I did do help first but i was serching for running balance.
I also tried to do a search on this site but MS is redoing
this site and search is turned off and will be for a
couple of weeks per MS.
but thanks for you help. it has pointed me in the right
direction.

I try to do more pointing than instructing.