DSUM answer=0, report text box displays nothing. 1

[CptCrusty1]

I have a report with dozens of calculated text boxes. All of them are DCOUNT's or DSUM statements. I have a DSUM calculating total hours (DSUM on Hours column). If the hours are zero (nothing to sum based on previously defined criteria), the textbox displays Nothing, and anything else that is linked to that textbox will also show nothing. I tried using an IIF(DSUM = 0,then, "0", DSUM) statement, which worked for the same problem on a form, but won't work on a report. Any ideas?
RK

 

[lupins46]

use NZ(Dsum()) and NZ(Dcount()) to force zeros into the answers

 

[CptCrusty1]

That worked... Thanks bunches Dude!!!!

Rich.