title: Crystal Reports - Sum values where another field isn't a certain value
body: <p>I am attempting to create a report using Crystal Reports which is tied to a dataset.  I am using a foxpro connection to retrieve my data.  In the table there is an <code>hours</code> field and there is a <code>transaction code</code> field as well as a client field, invoice number, and a few others that are pointless in this case.  </p>
  
  <p>Using <code>Crystal Reports</code> I am trying to get a <code>summary of the hours</code> where the <code>Transaction Code</code> is not <code>"NTX"</code>.  </p>
  
  <p>I am not able to modify my query to exclude <code>"NTX"</code> because I will still need to get a total of all transactions regardless of the transcode.</p>
  
  <p>A SQL query would be:</p>
  
  <pre><code>SELECT Sum(Hours) FROM table WHERE Transaction &lt;&gt; 'NTX'
  </code></pre>
  
  <p>Any help would be appreciated.</p>