IsNull

  • Thread starter Thread starter srctr
  • Start date Start date
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) & ","
 
Try something like:
="Dear " & Nz(strConv([Alias],3),StrConv([FirstName],3)) & " and " +
StrConv([SpouseName],3) & ","
 
Back
Top