Experts, I need my query (in the attached sample db) to return a cumulative amount for each tblDraws_Details1.[Amount]
("Draw Amount" as shown in the pic) however in the pic below, you can see I have a 0 in the first row but what I need to return is 1.2B (the amount of the first Draw Amount) and the next row below it in the same column should be $1,200,000,000 + $12,061,706.00
= $1,212,061,706.00. What I am looking for is a running sum for tblDraws_Details1.[Amount]
and keeping the same where condition: T.FacilityType=Q_Disbursem
How would an expert do this? I have taken too much time trying to modify.
I have attached a database.
Please open the query: Q_DisbursementSum