• DECLARE @startdate datetime

    declare @enddate datetime

    set @enddate = '10/1/2014'

    SET @startdate = '10/11/2014'

    select field1,field2,COUNT(FIELD3) from TABLE where date between @startdate and @enddate group by field1,field2