IIF in report

[mithani]

Hello all,

There is one field "DeliverDate" on my purchase order report. What I want that if this field is empty, then should print "ASAP" otherwise print delivery date. I am giving this command but showing error:

IIF([deliveryDate]=null, "ASAP", [deliveryDate])

Thanks

mithani

 

[boblarson]

You're close, but not quite there:

=IIF(IsNull([deliveryDate]), "ASAP", [deliveryDate])

 

[mithani]

thanks bob but showing #Error

 

[boblarson]

Make sure that your deliveryDate field name and text box are not named the same and then use the field name in the delivery date spot.

 

[mithani]

thanks bob, working perfect.

mithani