IIf help

L

LPL

I have a database that has 2000+ contacts including names, addresses, phone
numbers, etc. I have created a report to act as a phone book, and in the
interest of saving space, I have used IIF statements to display only the
fields that have data in them, and I have made the fields very small and set
them to 'grow' if necessary; for example, I may have a work phone # for
someone, but not a mobile, and vice versa. My IIF statement is as follows:

=IIf(Not IsNull([WWorkPhone]),"Work Phone: " & [WWorkPhone] & Chr(13) &
Chr(10) & IIf(Not IsNull([WWorkFax]),"Work Fax: " & [WWorkFax] & Chr(13) &
Chr(10) & IIf(Not IsNull([WMobile]),"Mobile: " & [WMobile] & Chr(13) &
Chr(10) & IIf(Not IsNull([WPager]),"Pager: " & [WPager] & Chr(13) & Chr(10) &
IIf(Not IsNull([WFamilyName]),"Family: " & [WFamilyName] & ", " &
[WFamilyPhone])))))

The problem is that if there is no work phone, none of the following data is
printed (mobile, pager, etc.)
Is there a way to have more than one iif statement in a field that is not
dependent on the first?

Thanks for any help.
Lisa
 
R

Rick B

Why not just have several IIF statements....

If =IIf(Not IsNull([WWorkPhone]),"Work Phone: ","") & [WWorkPhone] & IIf(Not
IsNull([WWorkFax]),"Work Fax: ","") & [WWorkFax] & ...


Basically, conditionally print label & print value & conditionally print
next label & print next value & condotionally print third labe & print third
value...
 
Top