By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

running totals in report

P: n/a
I have a report I created which pulls all data by month by category and
gives me running totals month by month. My problem is I need the ending
balance running total to move down to the next line in the report as a
beginning balance. How can I set that up in the report? I also need to put
a zero in the Jan06 Beginning Balance column.

Example:

Period Begin Bal Accruals Pymts
Rcls WO Ending Bal
Jan06 0 1000.00 500.00
100.00 50.00 350.00
Feb06 (need to put 350.00 here from previous month ending bal)

Any suggestions would be appreciated.

Thanks,

Tom
Oct 18 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
If I understand the math here this will get you what you want.
You have six columns in the report, Begin Bal, Accruals, Pymts,
Rcls, WO and Ending Bal.
In your report they occupy 6 controls (textBoxes) proceding
from left to right in the detail section of your report.
For ease of reference I will refer to the controls as tbA, tbB, tbC,
tbD, tbE and tbF
You have data for each control except tbA. The value of the
Beginning balance can be calculated as
tbA = tbB-(tbC+tbD+tbE+tbF).
So make your control tbA an unbound TextBox with content of
"=tbB-(tbC+tbD+tbE+tbF)" using the real names of those controls.

The better way to do this would be to pick up the beginning
balance in your query.

Kevin C

"Tom Brown" <th*****@tampabay.rr.comwrote in message
news:D0*******************@tornado.tampabay.rr.com ...
>I have a report I created which pulls all data by month by category and
gives me running totals month by month. My problem is I need the ending
balance running total to move down to the next line in the report as a
beginning balance. How can I set that up in the report? I also need to
put a zero in the Jan06 Beginning Balance column.

Example:

Period Begin Bal Accruals Pymts Rcls
WO Ending Bal
Jan06 0 1000.00 500.00
100.00 50.00 350.00
Feb06 (need to put 350.00 here from previous month ending bal)

Any suggestions would be appreciated.

Thanks,

Tom

Oct 19 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.