Multiple IIF Criteria in Access
<p>I have two fields <code>A</code> and <code>B</code>. I want an <code>IIf</code> condition together to form a field</p>

<p>I am trying to combine two following conditions :</p>

<pre><code>IIF(A AND B) IS not NULL,0,0) As Col

IIF(A Is not NULL AND B IS NULL),1,0) As Col
</code></pre>

<p>How Can I combine these two conditions to form the field Col?</p>