title: How to include zero-count results in query
body: <p>I have these two tables:</p>
  
  <p>Operators:</p>
  
  <pre><code>Id Nome
  --+----
   1 JDOE
   2 RROE
   3 MMOE
  </code></pre>
  
  <p>Calls:</p>
  
  <pre><code>Id CallDate OpId
  --+--------+----
   1 20161228    2
   2 20161228    3
   3 20161228    2
   4 20161228    3
   5 20170104    1
   6 20170104    2
   7 20170104    1    
  </code></pre>
  
  <p>And this query:</p>
  
  <pre><code>SELECT Operators.id, Operators.Nome, Count(Calls.OpId) AS CountCalls
  FROM Operators LEFT JOIN Calls ON Operators.id = Calls.OpId
  GROUP BY Calls.CallDate, Operators.id, Operators.Nome
  HAVING Calls.CallDate=20170104;
  </code></pre>
  
  <p>Which returns:</p>
  
  <pre><code>Id Nome CountCalls
  --+----+----------
   1 JDOE          2
   2 RROE          1
  </code></pre>
  
  <p>How can I make it return this, instead?</p>
  
  <pre><code>Id Nome CountCalls
  --+----+----------
   1 JDOE          2
   2 RROE          1
   3 MMOE          0
  </code></pre>
  
  <p>That is, how to include in any query also the zero results from main table which has no occurrence in left joined table, at least in the data slice defined by the query filtering criteria?</p>
  
  <p>This is Access 2013.</p>
  
  <p>I've read <a href="https://stackoverflow.com/a/14793090/3718031">this answer</a> but couldn't see how it is different from what I'm doing.</p>