add text to if,then expressions

[Guest]

trying to add Text and an operand to an if,then expression

 

[Rick B]

Ok.

If you tell us your expression and what you want to add to it, perhaps we
can help you.

 

[Guest]

Ok.

If you tell us your expression and what you want to add to it, perhaps we
can help you.

--
Rick B






Well thanks! I have been using IIF expresion. I want to add together the following:

Name Field and if Second Name field is empty, return only First Name field,
but if not empty, return first and second name fields, connected with an
ampersand. So far the ampersand is returned with the First Field even when
the second is empty.