title: Microsoft Access Count unique values per id
body: <p>I have an access database that has an id referring to a customer who has trucks of different sizes. currently the table looks something like this:</p>
  
  <pre><code>id.....tire size
  1......30
  1......30
  1......31
  1......31
  2......32
  </code></pre>
  
  <p>What I want to achieve is something like this:</p>
  
  <pre><code>id.....30.....31.....32
  1......2......2......0
  2......0......0......0
  </code></pre>
  
  <p>where it counts the number of occurrences of a specific tire size and inputs it into the respective tire size column.</p>