title: Combining Round with ISNULL in a query
body: <p>I have searched around but have not managed to find an answer.  Is it possible to combine Round, Sum and isnull in an access SQL query?  I have been trying to code the following query:</p>
  
  <pre><code>ROUND(sum(iif(isnull(amount,0,amount))),2) as Amount
  </code></pre>
  
  <p>However I have had no success with the above or other variations.  Is my SQL flawed?</p>
  
  <p>If my SQL is flawed, I'd be grateful if someone would be able to supply me with the correct syntax.</p>