how to build query to give daily balance across bank accounts? (to then plot in a graph)

[mixedup]

How to build query to give daily balance across bank accounts? (to then plot in a graph)

Assumptions:
* There is a table TRANSACTIONS which includes columns TRANS_DATE, AMOUNT and BANK_ID. It does NOT include a column for balance. So current balance for a bank account is the sum of the AMOUNTs for that BANK_ID for example. Balance on date XX will be the sum of all AMOUNTS for that BANK_ID for all TRANS_DATE's prior and including the date XX.
* Table BANKS which has BANK_ID and TITLE

Would like a query that gives: Supply StartDate and EndDate for the query:
Date Bank1Balance Bank2Balance Bank3Balance TotalBalance
1/1/15 $100 $200 $100 $400
1/2/15 $200 $200 $100 $500
.
.
.



etc

[June7]

Textbox on report has a RunningSum property which can easily do the sum.

This is actually not easy to do in query and therefore difficult to graph.

Review:

http://allenbrowne.com/ranking.html

http://allenbrowne.com/subquery-01.html#YTD

http://www.office-archive.com/10-ms-...a88aafd188.htm