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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate Start and End Date of a Quarter 11
Create report that shows a previous balance as of a date entered on a form 6
Calculate interest amount based on average daily balance 1
Balance Forward 4
How to create a "point in time" calculation that is date stamped 1
Please Help with Query to Return a Balance Column 5
Query for Running Inventory Balance 1
Selecting first record from a sorted query 6

Top