title: access2016: sql query to get sum per date
body: <p>Pls help</p>
  
  <p>in access 2016 query, I have a table status with fields &amp; datatype:
  date_created (date/time)
  status (shorttext)
  type (shorttext)</p>
  
  <p>I want to calculate the total number of count of request for each day. </p>
  
  <p>Using below select: </p>
  
  <pre><code>SELECT tbl_status.date_created, tbl_status.Type, COUNT(Type) AS No_Type
  FROM [tbl_status]
  GROUP BY tbl_status.Type, tbl_status.date_created
  ORDER BY tbl_status.date_created;
  
  
  date        Type      No_Type
  28-Sep-18   Sales       5
  28-Sep-18   Marketing   3
  27-Sep-18   Marketing   1
  05-Sep-18   Marketing   2
  05-Sep-18   Sales       1
  05-Sep-18   Account     6
  </code></pre>
  
  <p>for 28-sep-18 total_count_per_day should be 8</p>