Make Calculation in Report IF Check box is checked in form

[johnjmcnaughton]

I'm having a bit of trouble with a check box. I have a report that is used as a Purchase Order, and is getting info from a form. On the Form I put a Check box. I want the Report to calculate Sales Tax if the Check Box is checked on the Form. I have tried researching IF statements and have not been able to get it to work correctly. The expression I want is =SUM([Subtotal])*(0.07). If the Check Box is not checked I want it to be zero. I thought the if statement would be something like this: =iif([SalesTax])=True, "=SUM([Subtotal])*(0.07), "0".


Any Suggestions????

[rpeare]

on your REPORT in your sales tax field you can have a formula like:


=iif([forms]![formname]![salestaxcheckboxname] = -1 then, <Sales Tax Calculation>, 0)