S
srctr
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) & ","
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) & ","