Question

[Penny]

In a report how would I pull into a text box the following
requirements:

Pull Field (LOB Head)If Field (LOB) = "RE"
or If Field (DH) is null then Field (LOB Head)



Thanks in Advance
Penny

 

[Guest]

Use the following IIF statement:
=IIF([LOB] = "RE" or [DH] is null,[LOB Head],"")
That is if I understood your question correctly.
Hope this helps.
Fons