title: MS Access query sum up the values when certain columns match
body: <p>I have an Access database holding shoot days for commercials and line items tied to each shoot day. </p>
  
  <p>So I'll have something like...</p>
  
  <pre><code>Shoot Day      ......      Total
   Travel                     400
   Travel                     150
   Travel                     200
     1                        350
     1                        275
     2                        850
     2                        500
    ...                       ...
  </code></pre>
  
  <p>This goes on for a while. I want a query to return something like</p>
  
  <pre><code>Shoot Day      .......     Total
   Travel                     750
     1                        625
     2                       1350
    ...                       ... 
  </code></pre>
  
  <p>So I'd like it to add up the total column whenever there is a match in the Shoot Day column.</p>
  
  <p>I'd love some help! </p>