title: Access/VBA - Creating an new table with grouped records
body: <p>I've been thinking about my problem and researched here and the on the internet. I don't seem to get a step further...</p>
  
  <p>I have a database with different tables. One of them is like a client table. Every client has to send in forms (up to 3) each months, this is in a second table.</p>
  
  <p>It looks somewhat like this:</p>
  
  <pre><code>**tblReportedFiles**
  ID Month Form
  1 201803 1
  2 201803 1
  1 201803 2
  2 201804 2
  3 201804 3
  1 201804 1
  </code></pre>
  
  <p>My goal is to create code that will create a new table with the following dataset:</p>
  
  <pre><code>    clientID - ReportingMonth - Form 1 - Form 2 - Form 3
          1         201803         true     true     false
          2         201803         true     false    false
          3         201803         false    false    false
          1         201804         true     false    false
          2         201804         false    true     false
          3         201804         false    false    true
  </code></pre>
  
  <p>I just cant to get anything to work. I playe around with SQL and VBA but nothing goes into the right direction.</p>
  
  <p>Do you have any ideas?</p>