I tested the nz(RS2!CompanyID,0) and nz(RS2!CompanyID, " ") and I received the following errors
Error 94 invalid use of null (debug.print one) and 3075 missing operator with debug.print two
Error 94 invalid use of null (debug.print one) and 3075 missing operator with debug.print two
Code:
plancarrier=1 And entityid=2 And benefitsID=1 AND plantype=7 AND plandatailid=60 AND year(invoicedate)=2016 AND month(invoicedate)=2 AND CompanyID=0
plancarrier=1 And entityid=2 And benefitsID=1 AND plantype=7 AND plandatailid=60 AND year(invoicedate)=2016 AND month(invoicedate)=2 AND CompanyID=