>>I am not sure what you mean by precision the field for quantity is a character and the length is 10 characters if this is not the proper answer please tell me.
>>
>>Thanks again
>>
>>Fred W.
>
>Fred,
>
>If this is a character field (hmmm, quantity? :) then how would you suggest to sum it?
>
>I believe in your case you would need to use report variable and use Val(quantity) instead for calculations (assuming all of the fields are actually numbers just represented as a character field).
>
>Or may be you can create a cursor with the numeric field (using CAST function) for the reporting purposes (if you're already using some cursor)?
He can also just use VAL(quantity) as the expression for the field in the report, it will sum OK. No need for a report var.