>>When I am in the report designer (deposit.frx) and preview the report, my totals at the bottom of the report are accurate. But when I "REPORT FORM deposit PREVIEW" in the click method of a button, the total is off by $.01.
>>
>>This is consistantly this way with the same set of data. With a different set of data, the totals are identical.
>>
>>Any ideas?
>>
>>TIA
>
>Watch you SET DECIMALS setting. This sounds like a rounding error.

I've confirmed that my SET DECIMALS is 2 both in the report designer and when the form is active.

I have decided that it has something to do with the val() function. I was summing val(strtran(dbf.field,',')). I went back and did the val(strtran()) at the data source level, and the report gets the sum correct each time (knock on wood) now that it's summing numeric values.