Help with labels, reports

[greenter]

I have a database where an idividual can have one of three different addresses - a law firm, an individual office or home. I need to create mailing labels and form letters that use the address fields that are not null. I can do an IIF statement that compares two values, but evaluating three addresses is beyond my skill leve.

 

[rajeessh]

IIF(IsNull(field1) or IsEmpty(field1) or Len(field1) = 0,
,IIF(IsNull(field2)or IsEmpty(field2) or Len(field1) = 0,field3,field2),field1)

Try the above iif
the field1,field2,field3 are fields for variuos addresses