I'm trying to put together a nested IIf statement and am having a bit of syntax trouble. The statement is going in a textbox on a subreport. There are two fields in the subreport that I'd like to evaluate: EstimDate and Status. I would like for a text string "Additional Correspondence:" to be displayed if EstimDate is not null, OR if Status = "M7" (which is just a status category). I already had the syntax correct for the evaluation of the EstimDate portion of this,
(=IIF (IsNull ([EstimDate]), " ", "Additional Correspondence:") but have recently added Status="M7" as another criteria, and don't know exactly how to nest it.
Any Ideas?



