title: IIF statement with a Yes/No Field
body: <p>I have a question about using an IIF statement with a Yes/No field. In my case, I am trying to get the statement do one thing if the Yes/No field=Yes and another if it is "No." I realize Access stores the Yes/No field as -1,0 and have attempted to formulate the statement this way.</p>
  
  <p>I did make this statement:</p>
  
  <pre><code>NetDonation: IIf([PickupRequired]-1,[DonationValue]-8.75, 0, [DonationValue])
  </code></pre>
  
  <p>Unfortunately, this statement does not differentiate between the PickupRequired field being "No" or "Yes" and it subtracts 8.75 from all values regardless if the PickupRequired field = No.</p>