Combine TWO IIF(IsNull) Expressions into one control

[chapmajm]

Is it possible to combine two IIf(IsNull) Expressions into one control on a report in design view or in a query without having to do concatenating and looping and what not?

=IIf(IsNull([Constitutional]),"CONSTITUTIONAL SYMPTOMS: None ",("CONSTITUTIONAL SYMPTOMS: ") & " " & [Constitutional])

I want to be able to put multiple expressions into one control so that my report is like a paragraph.

If not, I did try creating one query that puts all fields belonging in "Constitutional" into a column. Then I made another query with that query as its source and tried using the above code. It gave me an error about circular reference.

 

[boblarson]

Not sure exactly what you are wanting but

=IIf(IsNull([Constitutional]) OR IsNull([WhateverOtherField]),"CONSTITUTIONAL SYMPTOMS: None ","CONSTITUTIONAL SYMPTOMS: " & " " & [Constitutional])

OR

=IIf(IsNull([Constitutional]) And IsNull([WhateverOtherField]),"CONSTITUTIONAL SYMPTOMS: None ","CONSTITUTIONAL SYMPTOMS: " & " " & [Constitutional])

 

[chapmajm]

Ah, I think the AND is null expression will work. Thank you.

 

[chapmajm]

It did work. I'm so relieved. Thank you.