title: Need a Sum Query to Include Zero Totals
body: <p>I am using Microsoft Access with a simple database that totals employees' hours for billable clients. I created a query to sum the total number of billed hours per employee. I need it to also return workers with a zero sum. I cannot figure out how to properly do so in the same query.</p>
  <p>I am an accountant who has not written SQL in probably six years and never was especially proficient. I assume this should be a fairly easy fix for people that are more experienced. My SQL code is just what was generated by Access as I built the query in Design View. The code is:</p>
  <pre><code>SELECT [EYH Export].Worker, Sum([EYH Export].Hours) AS [Billed Hours]
  FROM [EYH Export] INNER JOIN [Job List] ON [EYH Export].Client = [Job List].Client
  WHERE ((([Job List].Billed)=&quot;Billed&quot;))
  GROUP BY [EYH Export].Worker;
  </code></pre>
  <p>It returns a list of workers with their name in the first column and the total number of billed hours in the second column. In order to include names with no billed hours, I believe that I should be using something like: COUNT ([EYH Export].Worker WHERE ([EYH Export].Client) IS NULL;</p>
  <p>I would really, really appreciate any suggestions. Just pointing me in the right direction would be a tremendous blessing.</p>
  <p>Thank you.</p>