Hello:
I am trying to get two database fields to display when the IIF statement is true.
Here's what I have.
=IIf((Left([guests1],1)<>" "),[guests1],"") , which gives [guest1] field value when [guest1] is not equal to " "
What I need to do is combine another field, [name] so that I get [name] & [guests1] when [guest1] is not equal to " "
TIA