Calculate Previous Balance as of a date

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
 
Top