>I keep getting an error that says: [SQL Column " missing.]
>
>I don't see anything wrong with my SQL Code:
>
>

>SELECT ;
>      Emp, Dept, Netwgt, Date, PN ;
>   FROM SCRAP ;
>   WHERE ;
>      LEFT(DATE,5)=>LEFT(DTOC(.txtBegDate.Value),5) AND ;
>      LEFT(DATE,5)<=LEFT(DTOC(.txtEndDate.Value),5) AND ;
>      SUBSTR(DATE,7,2)=SUBSTR(DTOC(.txtBegDate.Value),7,2) AND ;
>      NOT remnant ;
>   ORDER BY ;
>      LEFT(ALLTRIM(DEPT), 2) + SUBSTR(Date, 7, 2) + LEFT(DATE, 5) ;
>   INTO TABLE C:\Scrap\Scrap_Rpt
>

You cannot ORDER By expression. If it's really important then you should include this expression in the field list:

Select LEFT(ALLTRIM(DEPT), 2) + SUBSTR(Date, 7, 2) + LEFT(DATE, 5) as listorder,emp.... ;
Order by 1