R Rick B Mar 16, 2006 #2 Ok. If you tell us your expression and what you want to add to it, perhaps we can help you.
G Guest Mar 16, 2006 #3 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: Click to expand... 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.
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: Click to expand... 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.
