title: How to display a zero in a cell when the count is zero? (MS Access 2010 Query)
body: <p>I've looked over some of the related questions but could not find a solution specific to my problem. I've created a cross tab query using MS Access on a table that has the fields department name and created on (date field). I've grouped the department names in the first column and have a count of id's to show the total number of items created in this week. Here is my SQL Query.</p>
  
  <pre><code>TRANSFORM Count([Issue Mgt].ID) AS CountOfID
  SELECT [Issue Mgt].[Deparment Name], Count([Issue Mgt].ID) AS [Total Of ID]
  FROM [Issue Mgt]
  WHERE (((Format([Created],"ww"))=DatePart("ww",Date())))
  GROUP BY [Issue Mgt].[Deparment Name]
  PIVOT Format([Created],"ww");
  </code></pre>
  
  <p>What I'm struggling to do is display a zero in a cell where the count is zero. Any help is appreciated and pardon me if my question is poorly structured as its my first ever post here!</p>