Freddie,

Remove the comma after "Num_chgs". The last field in a SELECT should not have a comma after it.

>Then a Program Error ---Command is missing required claus.
>Procedure: runreport
>LPARAMETERS cStatus, cInputYear
>SELECT ;
>Llspm, ;
>Status, ;
>Start, ;
>Comp, ;
>Ssp, ;
>Msr, ;
>Avail, ;
>Ship, ;
>Hull, ;
>Num_Chgs, ;
>FROM Schd ;
>WHERE Status = cStatus AND ;
>left(SSP,2) = cInputYear
>INTO CURSOR Rptstatus1
>
>Select Rptstatus1
>REPORT FORM Rptstus1 PREVIEW