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.