My SELECT statement requires 2 substitution field names and I can't get it to work with 2 substitution field names. It works with 1 substitution field name (cField1 and &cField1), but not with 2.

For example:

cField1 is a key field. cField2 is a date field.

cField1 = cRetVa1
cField2 = cRetVal2

SELECT mytable.&cField, mytable.&cField2 FROM mytable ;
WHERE YEAR(mytable.&cField2) = YEAR(DATE()) ;
ORDER BY mytable.&cField ;
INTO CURSOR rpt

Thanks for your help.