Hi, All
I am having a brain cramp today , again. I am getting the above message on the following sql select statement. I had it in debug mode, and every table field had a value to it, be it blank or with the correct data. None of them were not found.

  SELECT tsks.clientid, tsks.prjnum, tsks.comp_num, ;
    tsks.task_num, "1" AS adj_num FROM tsks ;
    WHERE tsks.clientid + tsks.prjnum + tsks.comp_num NOT IN ;
    (SELECT DISTINCT adnt.clientid + adnt.prjnum, ;
    adnt.comp_num, adnt.task_num FROM adnt) ;
    INTO CURSOR ctsks

TIA
Beth