473,320 Members | 1,799 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

running totals in report

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
1 2098
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Bill Dika | last post by:
Hi I am trying to calculate a running total of a calculated textbox (tbAtStandard) in GroupFooter1 for placement in a textbox (tbTotalAtStandard) on my report in Groupfooter0. The problem...
1
by: Maddman | last post by:
I'm in the process of converting an Access database into a SQL 2000 database using Access Project as a front end. Here's where I'm stuck. I've replaced the old access queries with user-defined...
6
by: KashMarsh | last post by:
Trying to show running totals on a report, except it needs to show one total amount and values being subtracted from it. For example, the report shows a Total Inventory amount (TotInvAmt). And...
0
by: Beacher | last post by:
Hi all, I'm having troubles with a report I've created. You make some selections on a form which then sets a reports filter property and opens the report, this works fine. One bigger problem...
2
by: Jana | last post by:
Using Access 97. Background: I have a main report called rptTrustHeader with a subreport rptTrustDetails in the Details section of the main report. The main report is grouped by MasterClientID. ...
3
by: mochatrpl | last post by:
I am looking for a way to make a query / report display the running average for total dollars. I have already set up a query to provide totals dollars per day from which a report graphly shows...
4
by: Micheal | last post by:
Greetings Access Group, Being relatively new to Access, I try to work through problems on my own and have been very successful, although I have a conundrum that I have been working on for two days...
5
prn
by: prn | last post by:
Hi folks, I'm looking for a little advice here. I need to create a report that is totals only, with no detail records. I have a database with a lot of individuals (people) and the report has to...
6
by: Stuart Shay | last post by:
Hello All: I have a array which contains the totals for each month and from this array I want to get a running total for each month decimal month = new decimal; month = 254; (Jan) month =...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.