Report Running Sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My 1st table consists of Acct # and Names. The 2nd table has the deposits
and charges entered. Each account has a beginning balance, but I am not sure
which table to enter that in. I want a report that lists Accounts and their
transactions per dates I enter and will list the new ending balance on the
report. Right now my report lists the transactions per date but the ending
balance is just the transactions that were done between the two dates I
requested.

Example of Current Report: (the previous balance for April is $10.00)
5/1/05 - 5/31/05
Acct #: 2 Acct Name: Sales Tax
Date Description Deposit Charge Balance
5/1/05 Deposit $2.00 2.00
5/5/05 Charge 1.00 1.00

Total 1.00

What I want me report to look like is: (the previous balance for Apr is
$10.00)
5/1/05 - 5/31/05
Acct #: 2 Acct Name: Sales Tax
Date Description Deposit Charge Balance
5/1/05 Deposit $2.00 12.00
5/5/05 Charge 1.00 11.00

Account Total 11.00

I hope this makes sense. I have been pulling my hair out on this one.
 
Hi Sonya

I am trying to do the same thing. Did you ever figure this out or ge
an answer somewhere else

Thanks
Heathe
 
Sonya said:
My 1st table consists of Acct # and Names. The 2nd table has the deposits
and charges entered. Each account has a beginning balance, but I am not sure
which table to enter that in. I want a report that lists Accounts and their
transactions per dates I enter and will list the new ending balance on the
report. Right now my report lists the transactions per date but the ending
balance is just the transactions that were done between the two dates I
requested.

Example of Current Report: (the previous balance for April is $10.00)
5/1/05 - 5/31/05
Acct #: 2 Acct Name: Sales Tax
Date Description Deposit Charge Balance
5/1/05 Deposit $2.00 2.00
5/5/05 Charge 1.00 1.00

Total 1.00

What I want me report to look like is: (the previous balance for Apr is
$10.00)
5/1/05 - 5/31/05
Acct #: 2 Acct Name: Sales Tax
Date Description Deposit Charge Balance
5/1/05 Deposit $2.00 12.00
5/5/05 Charge 1.00 11.00

Account Total 11.00
Click to expand...


How do you figure out what the previous balance is?

How do you tell the difference between the charges and
deposits?

Please be specific by using table and field names to
explain.
 
I actually figured a different way to do my tables. I couldn't figure out
how to copy a calculated field from one report to another. Ken Snell helped
me with that problem yesterday. So, I have my question answered, but thank
you anyway.
 
Back
Top