MS Access query sum up the values when certain columns match <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>