I'm using the following. Report ID: IIf([Msamplenumber1] Like "*H*" Or [Msamplenumber2] Like "*H*","In Progress",[Mreportid]) How can I add if Mreportid is null, then "Empty" to the above statement? Thanks