title: How to write a query in MS Access 2007 to display more than one value in more than one column?
body: <p>I have a table.</p>
  
  <p>Table Name:<code>tblRAC</code></p>
  
  <pre><code>Examiner Subj scheme pap_code moderator pap_accessed  pap_moderated
  Kamble   DTE   EJ1E   12116    mahulkar     25            5
  kamble   AEL   DE4E   12110    Patil        2             2
  kamble   DTE   CO3C   12064    Nale         37            20
  kamble   DTE   IF3E   12064                 01            
  Kamble   DTE   IL1E   12116    kulkarni     35            5
  </code></pre>
  
  <p>How to write a query in MS Access 2007 to get output as below.</p>
  
  <pre><code>subj    pap_Code   scheme      pap_accessed moderator
  DTE      12116    EJ1E,IL1E     60          mahulkar,kulkarni
  DTE      12064    CO3C,IF3E     38          Nale
  AEL      12110    DE4E          02          Patil
  
                      Total  100    
  </code></pre>