Syntax for IIf Statement 1

[bethabernathy]

Hi - I have a report that lists the field "IncidentDescription". I want the "IncidentDescription" to display only if there is data in the field. If the record is empty, I don't want the field to display. I have the following Syntax in the text field, but it is working yet:

=IIf([IncidentDescription]="Null"," &quot

Any suggestions??

Thanks, Beth beth@integratedresourcemgmt.com

 

[JohnLowell]

I think it should be:

=IIf([IncidentDescription]=Null," ",[IncidentDescription])

You could also try:
=NZ([IncidentDescription]," &quot


Let me know if this helps.

 

[tempclerk]

Nothing equals Null. Try IsNull([IncidentDescription]).