title: using a SUM IF formula in Access
body: <p>I am trying to sum "Order Qty" from a table in my Access database where "Material group name" equals "Generic Rx" through a Sum if formula</p>
  
  <p>I am using:</p>
  
  <pre><code>Gen Ordered: SUM(IIF([Material group Name]=(Generic Rx).[Order Qty],0)
  </code></pre>
  
  <p>but I am getting an invalid syntax error at the Generic Rx expression</p>
  
  <p>"Generic Rx" is value within the "Material group name" column</p>
  
  <p>what is the best way to go about this? Thanks</p>