>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)?
If it's not broken, fix it until it is.
My Blog