I have a VIP report to pull with comments.
There is a vipcode field and a commenttype field. I need three different vipcodes and the comments from three different commenttypes; however even if the commenttype is null and the person has the vipcode I need that person to print on the report.
So vipcode in [V1,V2,V3] and commenttype in [HSP,FO,VIP] and of course null. Tried a if/then/else... no luck.
Thanks in advance- River_k
There is a vipcode field and a commenttype field. I need three different vipcodes and the comments from three different commenttypes; however even if the commenttype is null and the person has the vipcode I need that person to print on the report.
So vipcode in [V1,V2,V3] and commenttype in [HSP,FO,VIP] and of course null. Tried a if/then/else... no luck.
Thanks in advance- River_k