title: How to create an Access crosstab query with totals for the columns AND the rows?
body: <p>I want my query result to look like this:</p>
  
  <pre><code>          Person1 Person2 Person3 Person4    Total 
  Status1         2       4       7       3      16
  Status2         0       1       0       3      4
  Status3         0       0       0       0      0
  Status4         0       1       3       0      4
  Total           2       6       10      6      24
  </code></pre>
  
  <p>I'm able to get everything except that bottom row with:</p>
  
  <pre><code>TRANSFORM Count(personName) 
  SELECT status, Count(status) AS Total
  FROM table1 
  GROUP BY status
  PIVOT personName
  </code></pre>
  
  <p>I found something about using a UNION to tack on the last row, but I can't seem to quite get that right.  Seems like this should be a common activity.</p>