Report Running Sum

[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.

 

[heathereandrews]

Hi Sonya

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

Thanks
Heathe

 

[Guest]

Sorry to say, but no, I haven't got the answer yet.

 

[Marshall Barton]

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

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.

 

[Guest]

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.