PARAMETERS date1 DateTime, date2 DateTime;
SELECT NameID, Count(Date) AS CountDate
FROM tbl
WHERE (Date Between [date1] And [date2])
GROUP BY NameID;

SELECT tbl.NameID, CountDate1, CountDate2 
FROM (
      tbl LEFT JOIN [SELECT NameID, Count(Date) AS CountDate1
      FROM tbl WHERE (Date Between DateStart And DateEnd1) GROUP BY NameID]. AS d1 
      ON tbl.NameID = d1.NameID
     )
LEFT JOIN
     [SELECT NameID, Count(Date) AS CountDate2
     FROM tbl WHERE (Date Between DateStart And DateEnd2) GROUP BY NameID]. AS d2
     ON tbl.NameID = d2.NameID;