title: access iif query do nothing when false
body: <p>My situation/problem:</p>
  
  <pre><code>TableA
  id, postalcode, region
  </code></pre>
  
  <p>Criteria for the field i want to add value in (<code>postalcode</code>):</p>
  
  <pre><code>=IIf([tableA.Region]="Chicago","60064",[postalcode])
  </code></pre>
  
  <p>What i need to accomplish is an iif-query where:</p>
  
  <p>In the field <code>postalcode</code> I check in the criteria if the field region equals <code>Chicago</code>. If so fill up the field with postalcode <code>60064</code> if not DO NOTHING</p>
  
  <p>For the do nothing part I'm using the fields name, this is wrong?
  am i using the criteria in the right field (the field i want to add?)
  I'm using a selection query?</p>
  
  <p>As you can see i'm a noob in access queries...</p>
  
  <p>Can somebody give me the right iff statement?
  Thx in advance,
  D</p>