>I have a table of drawing numbers. I have three fields: dwgno, start date, act start date. I want to do a report on delinquent drawings. I need a Select statement to give me all the dwg's that have not been started or were started late and all dwg's due within two weeks I need this in a scope of one week ago to two weeks in advance. Thanks for your help.

assuming start date means due date...

SELECT * FROM drawings ;
WHERE ;
  ( EMPTY(actstartdate) OR actstartdate > startdate ) ; 
  AND BETWEEN(startdate, DATE()-7, DATE()+14) ;
INTO CURSOR mycursor