title: Check null value in MS Access Query
body: <p>In SQL Server we can use IsNull() function to check whether expression value is null or not. For ex.</p>
  
  <pre><code>Select IsNull(sum(amount),0) as TotalAmount
    From Payments 
  </code></pre>
  
  <p>Likewise is there any function in MS Access Query to check the null? I need the same statement to be executed in MS Access Query.</p>
  
  <p>Can anybody tell me the replacement for <code>IsNull()</code> in MS Access?</p>