title: SQL query for calendar creation
body: <p>I'm creating an application in Microsoft Access that will be used for resource planning.</p>
  
  <p>My SQL table is roughly structured as follows:</p>
  
  <pre><code>ID    DATE    SHIFT    PERSON
  </code></pre>
  
  <p>What I'm struggling with is retrieving the data from the table in a way I can use to populate a planning form.</p>
  
  <p>I'm looking for something like this:</p>
  
  <pre><code>NAME     16/11    17/11    18/11    19/11    20/11    21/11    22/11
  Person 1 Day      Day      Day      Day      Day
  Person 2 Night    Night    Night    Night    Night
  Person 3 Day      Day               Day      Day      Day
  </code></pre>
  
  <p>However, I'm not getting anywhere near to finding an SQL query that will get me this result.</p>
  
  <p>Any ideas?</p>