I was wondering if anyone could point me in the right direction:
I've added two new queries (based off one original query) in order to get different totals. The last step is to get a running total from certain fields.
Surely I'm doing this the hard way but the general hierarchy is:
qryReportSumAirlineTransactions - 1st query which obtains previous record values to sum current and previous totals for fuel issued and received.
qryReportSumAirlineTransactionSubTotals - 2nd query (based on 1st query) which is used to (SUM new and prev issued) and (SUM new and prev received).
qryReportSumAirlineTransactionTotals - 3rd query (based on 2nd query) used to obtain a Total: Sum([SubtotalReceived]+[SubtotalIssued]).
Now, I need a a way (in a query) to perform:
Running Sum of PrevReceived
Running Sum of NewReceived
Running Sum of NewIssued
Attached are my sample queries and related tables. You can use the being/end date of 10/07/20 for testing.
Sidenote, I've noticed when I backup or copy these queries sometimes it takes forever or appears to hang; not sure whats up w/ that.
Any help is appreciated!
I've added two new queries (based off one original query) in order to get different totals. The last step is to get a running total from certain fields.
Surely I'm doing this the hard way but the general hierarchy is:
qryReportSumAirlineTransactions - 1st query which obtains previous record values to sum current and previous totals for fuel issued and received.
qryReportSumAirlineTransactionSubTotals - 2nd query (based on 1st query) which is used to (SUM new and prev issued) and (SUM new and prev received).
qryReportSumAirlineTransactionTotals - 3rd query (based on 2nd query) used to obtain a Total: Sum([SubtotalReceived]+[SubtotalIssued]).
Now, I need a a way (in a query) to perform:
Running Sum of PrevReceived
Running Sum of NewReceived
Running Sum of NewIssued
Attached are my sample queries and related tables. You can use the being/end date of 10/07/20 for testing.
Sidenote, I've noticed when I backup or copy these queries sometimes it takes forever or appears to hang; not sure whats up w/ that.
Any help is appreciated!