title: Arranging Columns in Microsoft Access
body: <p>I am using Microsoft Access to generate a report, but I'm encountering difficulty in figuring out how to have the information displayed in way that will comply to my preference. Specifically: the manner in which the data in my table is currently displayed is depicted below:</p>
  
  <pre><code>Day     Provider    Patient 
  1/27    Johnson     Claire
  1/27    Johnson     Tim
  1/28    Johnson     Craig
  1/27    Jane        Michael
  1/28    Jane        Lisa
  </code></pre>
  
  <p>However, I would like the data to display as follows:</p>
  
  <pre><code>Provider    1/27    1/28
  Johnson     2        1
  Jane        1        1
  </code></pre>
  
  <p>My understanding of SQL is admittedly rudimentary, so I have been only able to come up with the following query:</p>
  
  <pre><code>SELECT COUNT (Patient), Day, Provider
  FROM (SELECT DISTINCT Patient,Day, Provider FROM Records)
  GROUP BY Day, Provider;
  </code></pre>
  
  <p>Is what I'm looking for possible in MS Access? </p>