Hi Steve,
What is the error message are you getting?
>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.
kenweber
GCom2 Solutions
Microsoft Certified Professional