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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rolling total....again 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to create a rolling sum in a query 3
Duplicates - Query Joining 1
Rolling Totals for 6 month and 12 month 2
dsum sytax error 5
Group By problem 2
Crosstab Query - Recalculate totals after each date 2

Top