title: Getting a count by date based on the number of observations with encompassing date ranges
body: <p>I am working with a table in Microsoft Access whereby I have 2 columns with a start and end date. </p>
  
  <p>I want to get the count by date of the number of rows with date ranges that encompass the date in the output table. </p>
  
  <p><strong>Input Data</strong></p>
  
  <pre><code>Start Date  End Date
  01/02/2017  03/02/2017
  07/02/2017  19/02/2017
  09/02/2017  19/02/2017
  11/02/2017  12/02/2017
  12/02/2017  17/02/2017
  </code></pre>
  
  <p><strong>Desired Output</strong></p>
  
  <pre><code>Date    Count
  01/02/2017  1
  02/02/2017  1
  03/02/2017  1
  04/02/2017  0
  05/02/2017  0
  06/02/2017  0
  07/02/2017  1
  08/02/2017  1
  09/02/2017  2
  10/02/2017  2
  11/02/2017  3
  12/02/2017  4
  13/02/2017  3
  14/02/2017  3
  15/02/2017  3
  16/02/2017  3
  17/02/2017  3
  18/02/2017  2
  19/02/2017  2
  20/02/2017  0
  </code></pre>
  
  <p>For this project, I have to use Microsoft Access 2010, so a solution in either SQL code or design view input would be great.</p>
  
  <p>Any help on this would be appreciated. Thanks! </p>