Help on Run-On Calculation

[lazylamb]

Hello.
I’m new to this and trying to look for some guidance.

I have a query (query 1) that sum up my total value.



I want to create a query (Run on) that starts off with my SumofValue ($1000.00) from query 1. And then total another value from query 2 (Trans_Total) to give my first Run-On Total. After that, my first Run-On Total ($950.00) will be my start_Value for the next day (01/20/2015). And will total the next day Trans_Total to give me the 2^nd Run-On total.





Is this something possible in a query? Looking for any suggestions on how to approach this calculation. Thanks.

[June7]

This is a common topic. Have you done any research on running total/sum/balance?

In query is difficult. Easy with report. Use textbox RunningSum property.

Will have to pull in the SumOfValue result from Query1 into a textbox (call it tbxSV), suggest putting in header section. Couple options. One is a Cartesian relationship query that includes query1 and query2 so the $1000 shows on every record. Another is to use DLookup() expression in query or textbox or even DSum() on the raw dataset. Be aware either approach can perform slowly with very large datasets. Then bind a textbox (call it tbxTT) to Trans_Total field and set RunningSum property to "OverAll". Can hide textboxes if you want. In another textbox expression: =[tbxTT] + [tbxSV]

[CJ_London]

what is the rational for query1? does it represent a month or other time period? or some other basis? And is it based on the same table as the second query?

Also can you have more than one transaction on any given day?