>Hi Rick
>Still trying to get the SUM to work. Every time I use SUM(mydata), it returns the message "SUM.PRG not found. Suggestions? Thanks.

Don't use parentheses around the expression to be SUM'd. Using your other example, the correct syntax would be

SUM code1+code2+code3 TO loReg1July FOR reg='1' AND fy='01'

Note that there are no parentheses needed around the code1+code2+code3 expression.