Hi David:


LPARAMETERS cStatus, cInputYear
SELECT ; ------> Yellow Arrow
Ilspm, ;
Status, ;
Start, ;
Comp, ;
Ssp, ;
Ils_k, ;
Avail, ;
Ship, ;
Hull, ;
Num_Chgs ;
FROM Schd ;
WHERE Status = cStatus AND ;
left(SSP,2) = cInputYear
INTO CURSOR Rptstatus1

Select Rptstatus1
REPORT FORM Rptstatus1 PREVIEW

I am getting a program error showing Operator/operand type mismatch and a yellow arrow is pointing at SELECT verb.

Operator/operand type mismatch (Error 107)
An arithmetic, string, or logical operator or function is being used with an invalid data type. This error would occur, for example, if you were to attempt to add two logical values.

Question 1: Could this be blanks showing up in numeric field?

Question 2: Should TxtInputYear screen value be define as numeric field?