Total for Mulitple Dates

[durdle]

Hey Everyone,

I am tring to get a total for multiples dates in this case, shown in my query attached. The query just returns just totals for dates specified in the query. Do anyone know how I can get rollup?

Thanks in advance.
________
buy cheap vaporizer

 

[Nouba]

try this query

SELECT
  Sum(acd_calls) AS SumOfacd_calls
FROM tblstj
WHERE fdate In (#5/4/2003#,#5/11/2003#,#5/18/2003#,#5/25/2003#,#6/1/2003#,#6/8/2003#)