sele ;
iif( isnull(sum(b.totcxlcnt)),;
iif(isnull(sum(a.totsalecnt)),000,sum(a.totsalecnt)),;
sum(a.totsalecnt)-sum(b.totcxlcnt) ) as tsaleadj,;
From qcTSaleRp a FULL JOIN qcTCxlRp b ;
ON a.repid==b.repid AND a.pub==b.pub;
Group by a.Repid,a.Project;
Order by a.Repid,a.Project;
Into cursor qcSalCxl

... is still generating the message "TSaleAdj does not accept null values" I know there is something strange going on during the Select, but I don't know where nulls would come from if i'm checking for nulls. This problem is also data dependant- sometimes it works, sometimes it doesn't. (which makes troubleshooting that much easier!)