Yes, multiple variables on the report/label. In my label example they are located in the detail section.. Defined in the variables section. I call mine vline1, vline2, etc. In my database Company,address, city are never null.
vcsz = (city + ',' & state & country & zipcode) vLine1 = company - in my case is never null. vLine2 = (ifexists(coname2,coname2,address)) vLine3 = (IFEXISTS(Coname2, Address,(IFNULL(Coname2, (IFEXISTS(Address2,Address2,.vCSZ)),.vCsz)))) vline4 = (IFEXISTS(Coname2,(IFEXISTS(Address2,Address2,.vCSZ)),(IFNULL(Coname2,(IFNULL(Address2,' ',.vCSZ)),' ')))) The more variable you use, the more complicated it gets, but it works. I think the syntax is right on vline4, This was for Christmas cards and it's been a few months since I ran this report/label and I rewrote the final label in a backup I didn't keep. But you can get the nested ifnulls idea from this. I think I learned this from Razzak's work. Kenny > -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/0920dd34-590a-4d47-a7c7-ec01fcb41551%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
