Or Statement

[kitty77]

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

 

[June7]

Nz([Mreportid], "Empty")

Report ID: IIf([Msamplenumber1] Like "*H*" Or [Msamplenumber2] Like "*H*","In Progress", Nz([Mreportid], "Empty"))

 

[kitty77]

How would the code look with that added?

 

[June7]

I already edited answer, most likely while you were reading it. Review again.

 

[kitty77]

Perfect!

 

[kitty77]

Would about this part of the code?

 

[June7]

I don't understand last post. Is issue resolved or not?

 

[kitty77]

It just didn't seem correct but yes, it's just what I'm looking for. Thank You!