Just before you print the report, browse the table and confirm without a doubt that the numbers are as you expect and not rounded in the data.
Cathy
>Good day everyone,
>I have a report that seems to round up the values at the end of a page. If a field in the Page Header has a value of 106.16 then the bottom of the page (which is supposed to sum the fields on that page) gives a total of 106.20
>In the Report 'Page Footer' I have a field that Sums at "End of Page" and the field is supposed to be a currency so I set it to Numeric currency in the format "@$ 99999.99"
>The Field in the "Page Header" has the expression
>
>IIF(table1.field1<>0,table1.field1,"")
>
>and I don't have any format on it. I guess it's rounding to the tenths place but I don't know how to change it!
>Can someone please help me so I can get it to give the exact sum and not round up.
>Thanks!
>Max