View Full Version : IIF help


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?

boblarson
05-13-2007, 05:31 PM
You want to reference the field, not the text box. So, reference the field that is in Text49. Also, it would be [Pay Tax]=-1