Report/Subreport balance forward

  • Thread starter katiejay99 via AccessMonster.com
  • Start date
K

katiejay99 via AccessMonster.com

I need a little help please. I have a report which shows all deposits, checks
and a ending balance (as a running total) based on a date range (this works
fine)

I created a subreport which gives me a balance forward based on the same
begin date (-1) - the result is the balance forward for that account. - this
also works fine.

My problem is how can I make the running sum total add the balance forward
field only one time and have an accurate running balance with a correct
ending balance?

I am using MS Access 2003.

Thank you
 
A

Al Campagna

katiejay99,
I ran into this when I developed a SnowPlowing billing system.
I used a subreport (one line) to display and add a Previous Balance This month -1
month.
Another subreport (multiple entries) to display and add up the Current Charges for this
billing period.
And finally a 3rd subreport (one line) based on all transactions regardless of date,
which displayed just the Current Balance.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
K

katiejay99 via AccessMonster.com

Al, Thank you for your reply.

What I am trying to get at is this:
If you open your check book to any page, at the top is a place for balance
forward and then you or subtract entries to get a current balance.

I have the subreport which sums all checks and deposits and gives a balance
(by bank account) based on a check date which is based on a Report Date range
form. That works good.
The Detail report gives me all transactions based on the same Date Range
report.
So, on my report I have the balance forward showing in the header and all
transactions for the given period in the detail section with a running sum
balance.

But, I want the detail balance to include the balance forward, but only for
the first transaction so that in the end of the period I have the accurate
ending balance. Perhaps I am being to stubborn about that, but it is what I
would like to see - I just don't know how to go about doing it.

Thank you again,
Kathy


Al said:
katiejay99,
I ran into this when I developed a SnowPlowing billing system.
I used a subreport (one line) to display and add a Previous Balance This month -1
month.
Another subreport (multiple entries) to display and add up the Current Charges for this
billing period.
And finally a 3rd subreport (one line) based on all transactions regardless of date,
which displayed just the Current Balance.
I need a little help please. I have a report which shows all deposits, checks
and a ending balance (as a running total) based on a date range (this works
[quoted text clipped - 11 lines]
Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top