title: VB.NET/Access - SELECT SUM SQL statement
body: <p>I have a table with LastName, FirstName, Wins, Losses, CompFormat and Medals columns.  In case the person who told me not to use pictures on my last question sees this I tried your suggestion and couldn't figure it out so I have to use pictures.  So don't bite my head off this time.  I successfully added and grouped Wins with CompFormat like this...</p>
  
  <pre><code>("SELECT SUM(Wins) AS Total, FirstName, LastName, CompFormat FROM CompetitionDate GROUP BY LastName, FirstName, CompFormat;")
  </code></pre>
  
  <p>Which correctly produced this in my datagridview...</p>
  
  <p><a href="https://i.stack.imgur.com/wz4hl.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wz4hl.jpg" alt="Correct Outcome"></a></p>
  
  <p>Instead of what I did I want to add counting losses and group it to look like this</p>
  
  <p><a href="https://i.stack.imgur.com/MBOCO.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MBOCO.jpg" alt="enter image description here"></a></p>
  
  <p>Here is my access table...</p>
  
  <p><a href="https://i.stack.imgur.com/1puPf.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1puPf.jpg" alt="enter image description here"></a></p>