hi all
I have the following code that is giving a variable not found error on line 2

SELECT tempsorders
SUM ordqty TO mhistory FOR period > (mperiod-12) AND stkref = mstkref AND stage > "20"

tempsorders contains all of the fields in the sum line and all are named correctly, any ideas?
~M