G
Guest
I have been trying to calculate a running sum for consecutive dates. My SQL
for the query is as follows:
SELECT qrySKEmergenceStats.DATE_SAMPLED, qrySKEmergenceStats.SumOfSKPERHR,
(DSum("[qrySKEmergenceStats].[SumOfSKPERHR]","qrySKEmergenceStats","[date_sampled] <= " & qrySKEmergenceStats.date_sampled)) AS CUMSUM_SKPERHR
FROM qrySKEmergenceStats;
The query produces blank results. Thanks for your help!
for the query is as follows:
SELECT qrySKEmergenceStats.DATE_SAMPLED, qrySKEmergenceStats.SumOfSKPERHR,
(DSum("[qrySKEmergenceStats].[SumOfSKPERHR]","qrySKEmergenceStats","[date_sampled] <= " & qrySKEmergenceStats.date_sampled)) AS CUMSUM_SKPERHR
FROM qrySKEmergenceStats;
The query produces blank results. Thanks for your help!