title: MS Access IIf statement with multiple conditions
body: <p>I am trying to use an IIf statement in ms access 2000. I've searched around but have found nothing that accurately describes my situation. The current issue is when I try to use an IIf statement to output an answer dependent upon two parts or variables, it gives me a message stating that my syntax is incorrect. The line of code in question is as follows:</p>
  
  <p>=IIf([Sold]=Yes, And IIF([Paid]=No, Then,"Not Paid"))</p>
  
  <p>It gives me a message saying that my syntax is incorrect but upon removing the comma after the "Yes", it tells me that I've made too few arguments.</p>