>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
Can you add a numeric format to this? Perhaps you should just change the expression to Table1.Field1, and use conditional printing.
Sometimes the reporting system will round to less digits, if there isn't enough space to show all the desired digits.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)