title: Sum of column for another Group By column in delphi
body: <p>I'm working on a simple delphi form to create a daily balance sheet therefore i'm using a DBGrid having its columns from a table and containing:
  date, in, out..what I want to do is group by date and calculate the In and Out for each date in order to make the balance.</p>
  
  <p>Example: </p>
  
  <pre><code>     1/01/2013 in (100) out (0),
       1/01/2013 in (200) out (0),
       1/01/2013 in (0) out (100),
  </code></pre>
  
  <p>I want the result to be 1/01/2013 in (300) out (100)</p>
  
  <p>Any help Please cause I'm having trouble after grouping the dates.</p>