G
Guest
trying to add Text and an operand to an if,then expression
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Ok.
If you tell us your expression and what you want to add to it, perhaps we
can help you.
If you tell us your expression and what you want to add to it, perhaps we
can help you.
G
Guest
Name Field and if Second Name field is empty, return only First Name field,Rick B said: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:
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.