Rolling Total

W

wlrottge

I am trying to run a 12 month rolling total in access with this line of
code.

I have a query that pulls the data that I want out and filters and sums
it to fit my date range. "02c-02 Sum individual HAPS"

The fields in this query are:
TIME_FROM (GROUP BY)
POLLUTANT_CAT_CD (GROUP BY)
EMISSION_LBS (SUM)

I am trying to run my next query "02c-03 Rolling HAP Sum" that pulls
from the previous query with the following fields:
POLLUTANT_CAT_CD
TIME_FROM
SumOfSumOfEMISSION_LBS

the last field is:
Rolling_Total: DSum("[Rolling_Total]","[02c-02 Sum individual
HAPS]","[TIME_FROM]Between #" & [TIME_FROM] & "# And DateAdd(""D"",
-366, #" & [TIME_FROM] & "#)")

I don't get any error messages, but I don't get any results either.

Any help would be GREATLY appreciated.

Thanks,

Will R
 
Top