splitter
05-13-2007, 04:43 PM
Hey, im trying to write an IF function into a report to calculate total tax deduction on a certain textbox.
I have this
IIF([Pay Tax]=True,[Text49],"")
I want to display whats in Text49 if the Pay Tax Field is Ticked, as it is a Check box.
I keep getting the syntax error message when i try and view the report.
Anyone help?
I have this
IIF([Pay Tax]=True,[Text49],"")
I want to display whats in Text49 if the Pay Tax Field is Ticked, as it is a Check box.
I keep getting the syntax error message when i try and view the report.
Anyone help?