Hello and happy hump day

Where am I wrong on the below function? It is only showing the Inactive? ...

Status: IIf(IsNull([DateRented]),"Active",IIf(Not IsNull([DateLeft]),"Inactive"))

Thanks
Larry

P.S. : Never mind...I found it.. Status: IIf(IsNull([DateLeft]),"Active",IIf(Not IsNull([DateLeft]),"Inactive"))

Thanks

actually, since you are only testing for a single field and two conditions, you can simply use this


Status: IIf(IsNull([DateLeft]),"Active", "Inactive")

Or you could simplify it:

IIF([dateleft]is null,"Active","Inactive")