title: Access does not summarize null values of crosstab query row headings
body: <p>I think this should be simple but I have no found a solution so far.
  I have a table V_POLE_FR., which has a structure like this (it has more fields)</p>
  
  <pre><code>ROWID (integer pk)
  PROPRIETAIRE (string)
  STATUS_FINAL (string)
  </code></pre>
  
  <p>I would like to summarize the number of poles by PROPRIETAIRE (the crosstab row heading), and get the numbers of each STATUS_FINAL (the crosstab query column heading). I get OK results for all the owners (PROPRIETAIRE) but there are some null values of owner and I get a blank row but with 0 count.
  How can I get to sum up also the poles having null owner? I have tried Nz but maybe not doing it right.</p>
  
  <p>Here is my crosstab query:</p>
  
  <pre><code>TRANSFORM Count(V_POLE_FR.PROPRIETAIRE) AS [COUNT]
  SELECT V_POLE_FR.PROPRIETAIRE, Count(V_POLE_FR.PROPRIETAIRE) AS TOTAL_PROPRIETAIRE
  FROM V_POLE_FR
  GROUP BY V_POLE_FR.PROPRIETAIRE
  PIVOT V_POLE_FR.STATUS_FINAL;
  </code></pre>
  
  <p>And i get results like this (count of zero for nulls which should be 4):</p>
  
  <pre><code>PROPRIETAIRE TOTAL_PROPRIETAIRE   &lt;&gt;   A   B   C   D   E
  (null)              0              0
  X                   1                      1
  Y                   81                         75   2
  Z                   165                   165
  </code></pre>
  
  <p>The interesting thing is  if I do a simple group by query, I get the totals right but I loose the separation by status:</p>
  
  <pre><code>SELECT DISTINCT V_POLE_FR.PROPRIETAIRE, COUNT(*) AS TOTAL
  FROM V_POLE_FR
  GROUP BY  V_POLE_FR.PROPRIETAIRE;
  </code></pre>
  
  <p>I thank your help.
  By the way I looked at several answers and any seemed to be this case?? I tried the Nz function it did not work.</p>