Need help with IIF function

[RazMan]

I created a purchase requisition in MS Access 2003 and have been racking my brain on how to create an iif statement that would apply tax to a number by clicking a yes/no box. Below is what I'm trying to do:

If box is checked {Yes} then, tax equals total times 8.375%
If box is not checked {No} then, tax is zero.

It seems simple enough but I cant seem to make it work! Any assistance by he community would be greatly appreciated.

Thanks,



Raz

[ajetrumpet]

if the tax number is a text box, easy:

checkbox_on click

  if me.checkbox = false then
     me.taxamount=0
  else
     me.taxamount=me.totalfield * .08375
  end if

[pbaldy]

Try

IIf(Taxable= True, AmountField * .08375, 0)

which using Boolean logic can be shortened to:

IIf(Taxable, AmountField * .08375, 0)

In real life, you'd want to get the tax from somewhere rather than having it hardcoded.

[RazMan]

Try

IIf(Taxable= True, AmountField * .08375, 0)

which using Boolean logic can be shorted to:

IIf(Taxable, AmountField * .08375, 0)

In real life, you'd want to get the tax from somewhere rather than having it hardcoded.

Thank you VERY MUCH!! This worked perfectly for what I was trying to do.

Raz

[pbaldy]

Happy to help!