title: Posting a result of $0.00 in Access 2016 Field
body: <p>I operate in a state that collects sales tax on credit card fee charges. Our business is about <code>50/50</code> check versus credit card. I cannot figure out how to get a result of <code>$0.00</code> in a calculated field <code>[CC Fee]</code>.</p>
  
  <pre><code>([Price]+[CC Fee])*[Tax]= Total
  </code></pre>
  
  <p>Price is <code>[Price]</code> </p>
  
  <p>Tax is <code>([Price]+[CC Fee])*0.055</code></p>
  
  <p>Credit Card Fee is <code>[Price]*0.03</code></p>
  
  <p>I have a field <code>[CC Fee?]</code> which is a drop down box yes/no. If paid by check, NO - if paid by CC, Yes</p>
  
  <p>In <code>[CC Fee]</code> I use the following -  <code>IIF[CC Fee?]="yes',[Price]*0.03, "$0.00"</code></p>
  
  <p><code>[CC Fee]</code> is populated by <code>$(3% of Price)</code> if answer is YES. It will not populate with <code>$0.00</code> if the answer is NO.</p>
  
  <p>How can I populate <code>[CC Fee]</code> with <code>$0.00</code> if there is no CC Fee charged?</p>
  
  <p>Thank you in advance</p>