Originally Posted by
Pennypinscher
Hi, all. I'm hoping you can give me some guidance. I have a field in the Report Footer, [orride1] in which I'm trying to achieve the following: If the sum of [orride] is less than 0 (or 1, doesn't matter to me, however i can get it to work), then show it. If not, then show "0.00". I have a separate field doing "=Sum([orride]) and named it "orride1".
This is how I have the field reading: =Iff([orride1])<0,([orride1]), "0.00)
When I look at the report, the field [orride1] shows the expected results (-90000.00), but the calculation does not. I'm assuming there's something wrong in my calculation, but I can't see it.
Can any of you please help?
Thanks,
Penny