D
Dani2009
How can I calculate a balance as of a certain date for a particular customer?
Table Name : Transactions
Table Fields: Transactiondate, Transactionamount, TransactionDistrict ID
Activity:
TransactionDate TransactionAmount TransactionDistrictID
5/29/09 100.00 15
6/20/09 200.00 15
7/1/09 500.00 15
8/15/09 500.00 15
If I want to see the transactions and balance starting 7/1/09 I would like
to see the following:
Previous Balance 300.0
7/1/09 500.00
8/15/09 500.00
Current Balance 1300.00
Table Name : Transactions
Table Fields: Transactiondate, Transactionamount, TransactionDistrict ID
Activity:
TransactionDate TransactionAmount TransactionDistrictID
5/29/09 100.00 15
6/20/09 200.00 15
7/1/09 500.00 15
8/15/09 500.00 15
If I want to see the transactions and balance starting 7/1/09 I would like
to see the following:
Previous Balance 300.0
7/1/09 500.00
8/15/09 500.00
Current Balance 1300.00