Originally Posted by
hertfordkc
I'm not on my Access computer, so this is unchecked. I use the query design view and datasheet view to check on results as I get into more complicated calculations.
Say your query has fields, D1,D2,DT, Val1
In the design view, show those fields and add field NewV.
In the NewV field, NewV:iff(([DT]>=[D1]) AND [(DT]<=[D2]),Val1,0)
That should give you a zero if outside the date range or a value if in the date range.
Once you get that, add a sum on the NewV column and you are done.