title: SQL Statement IF EXIST(SELECT THEN ELSE) on MS ACCESS
body: <p>I have problem to show "NOT PAID" in MS Access SQL Statement:-  </p>
  
  <p>I using Nz and IIF functions but not get what I wants.</p>
  
  <pre><code>(Select Nz(m.amount, "NOT PAID")
   From monthly m
   Where  m.year = s.year
          AND m.month='February') As PayFeb
  </code></pre>
  
  <p>You can refer related <a href="https://stackoverflow.com/questions/32968447/sql-statement-join-with-case">this question</a>.</p>
  
  <p>This only show amount if record found, but PayFeb will empty if Record Not Found where it's should be show "NOT PAID".</p>
  
  <p>Please help me how to solve this matter.</p>