If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IsNull
I have a test box in a report. I want the item to appear as follows
Dear Husband and Wife, Here is the catch - I want to use the the Husband's Alias Name if he has one, if not his FirstName. And if there is a spouse I want it to say "and SpouseName", if there is no spouse it can't have the word "and" This is what I have: ="Dear " & (IIf(IsNull([Alias]),StrConv([FirstName],3),StrConv([Alias],3))) & " and " & StrCon([SpouseName],3) & "," It works great if there are two names. It isn't great if I don't have a spouse then it shows as Dear Tom and , How do I do the IIf(IsNull) around the & "and" &StrConv([SpouseName],3) & "," |
Thread Tools | |
Display Modes | |
|
|