IIf(IsNull)

K

Ken V

I have created a status report and want to indicate open or closed based on a
filed called ReviewComplete.

If the field contains a date I would like to display "Closed" in a field
called Status on the report. If it is blank I would like to display "Open" on
the report.

The report is based on a query. I tried using the following expression
Status:IIf(IsNull([ReviewComplete]),"Open","Closed"

It is not working. Any suggestions would be greatly appreciated.

Thanks,
 
Top