If-then statements in report

[crmorgan]

I have a report and I only want the field to show up if the field <30. For example

IIF([field1]<30,[field2],"")

I keep getting #Error on my report. I don't know where I'm going wrong in the formula.

Thanks,

 

[GKChesterton]

Use "Conditional Formatting" on that field for easier going.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[dhookom]

I'm not sure why you didn't copy the Control Source. If the Control Source is not just a field name you must begin the expression with an =. Also, I would return a Null rather than "".[tt][blue]
=IIf([field1]<30,[field2],Null)[/blue][/tt]
Also, make sure the name of the control is not the name of a field.

Duane
Hook'D on Access
MS Access MVP