Error in IsError??

[valkyry]

I have this in the ReportFooter
=IIf(IsError(Sum([SumOfBalance])),0,Sum([SumOfBalance]))
and I still get #Error#

I have =IIf(IsError([SumOfBalance]),0,[SumOfBalance]) in the detail and it works.

I don't know what I'm doing wrong for the Grand Total in the Report Footer.

HELP!

 

[valkyry]

NEVER MIND.

I figured out another way in my final report.

Those were sub reports. in the end I just needed my final report to validate the null value and calculate.

thanks!

 

[ThomasLafferty]

Have a look at the [!]Dsum[/!] function and see if it makes any sense.

Tom

Live once die twice; live twice die once.