Sum/Rounding issues from subforms

[apartain]

In the detail of my report I am extracting a sum from a hidden subform via the following:

=IIf([Materials Detail for WO Overview].Report.HasData =True,[Materials Detail for WO Overview].Report!Text19, 0)

Where Text19 is the sum of the items in the subform.

I also need a grand total of the Text19's, but because of the conditional statement in the field recieving the result, I can not simply sum them up at the bottom of the report,so I created another subform in my report footer with the exact data, also a Text19, and used (essentially) the same conditional statement.

The problem is the detail and the report footer results are off by pennies due to rounding issues.

Is there a better way to do this? What about an SQL statement which sums the data so I can completely lose both of my messy subforms and the conditional statements????? ?

Thanks in advance for any help provided.

[MSeda]

There is definitely a better way to do this. If you can post a better description of what you want to do in the report as well as describing the underlying tables/queries I'm sure we can find a way to do what you want with out hidden forms.
The fact that your Grand Total does not match the sum of the of the detail fields suggests that you are not rounding your currency values in a consistent manner. I generally avoid saving any currency value in a table that has more than two decimal places. By rounding immediately after performing any calculation that might yield a product with more than two decimal places like when multiplying by a percentage.
Sum(Round(myPri ce*myMarkUp,2)) will not yield the same result as Round(Sum(myPri ce*myMarkup),2) . I prefer the former as it rounds the number immediately after the additional decimal places were acquired. The latter is not necessarily wrong but could potentially cause a discrepancy if you are not meticulous about how and when you use it.
Setting the data type to currency does not automatically round to two decimal places.
Anyway post back the stuff I mentioned at the top and we'll see if we can get your report working.

[NeoPa]

I'm sure MSeda knows this, and will suggest it if it's required when your requirements are more clearly known, but there is a property on a TextBox within reports called 'Running Sum' which can be used to tally up totals in reports.