beginng balance

[Lina Manjarres]

I have a report where I calculate the ending balance of every customer in our
company in a period of time.
I do not have an idea of how can I make a beginning balance for every
customer in a given period of time.

Can any one help me? I will appreciate it!

Thanks a lot

Lina

 

[Al Campagna]

Lina,
Given that you know the billing period... say 1/1/07 to 2/1/07...
I use a Totals query in a seperate subreport to to show the sum (BalanceForward) of all
transactions before 1/1/07.
Another subreport shows all the transactions between 1/1/07 and 2/1/07 (detail with a
footer sum (CurrentCharges))
Add the BalanceForward to the CurrentCharges and you get CurrentBalance.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

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