title: MS Access Nz() Function not Recognised in MS Excel
body: <p>I'm trying to write an expression in MS Access which returns a string of text, <code>"New Policy"</code>, in the <code>Iif()</code> statement after it returns an error.<br>
  When I export the data from Access into Excel it tells me that <code>Nz()</code> is not recognised.<br>
  Is there an alternative to this function? My Access expression is as follows:</p>
  
  <pre><code>Nz(IIf([Policy Status]=[Input - WFAC Previous Day]![Policy Status 1],"Remains " &amp; [Policy Status],[Input - WFAC Previous Day]![Policy Status 1] &amp; " to " &amp; [Policy Status]), "New Policy")
  </code></pre>