>>Try putting pcValue with an ampersand. '&' like &pcValue
>>
>>This means that the SQL query will use the contents of the variable pcValue instead of the word 'pcValue' --- Larry
>
>I'm getting "variable 'TOTAL' not found".
the field that you are trying to sum is TOTALS not TOTAL. TOTAL is the name of the cursor.