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![]()