title: How to combine two rows of data from the same table?
body: <p>I have a table called document as follow:</p>
  
  <p><strong>document_table</strong></p>
  
  <ul>
  <li>document_id</li>
  <li>employee_id</li>
  <li>type (values can be <i>"transcript"</i> or <i>"testimonial"</i>)</li>
  <li>status ( value can be <i>"ready to print" only</i> </li>
  </ul>
  
  <p>Sample data as below.</p>
  
  <pre><code>doc_id   employee_id   type         status
  --------------------------------------------------
  1        S1234         transcript   ready to print
  2        S1234         testimonial  ready to print
  3        S2345         transcript   ready to print
  </code></pre>
  
  <p>I want result table to be like below.</p>
  
  <p><strong>Result_table</strong>:</p>
  
  <ul>
  <li>employee_id</li>
  <li>transcript </li>
  <li>testimonial</li>
  </ul>
  
  <p>I would like to write a sql query to combine the individual document records into one, based on employee_id, and based on the document type being either transcript or testimonial</p>
  
  <pre><code>doc_id  transcript     testimonial
  --------------------------------
  S1234   TRUE           TRUE
  S2345   TRUE           FALSE
  </code></pre>
  
  <p>I'm using MS Access 2010.
  How do I achieve this?</p>