Want IIF statement to show 0 when null value

[Trisha]

After hours of playing around i finally have my IIF statement working the proplem is now is that when the Value is null it gives a blank value on my Report. How do i get it to show the value of 0 when it is Null. can i use an isNull withen my IIf statement maybe nested what is best practice?

:banghead:

 

[pbaldy]

Try the Nz() function.

 

[Trisha]

I have used the Nz Function as follows but it still isnt working still not giving me the result of 0
=Nz(Sum(IIf(([Handling]>#00:02:00# And [Going]="YES"),1)))
Have i used it incorrectly?

 

[BlueIshDan]

NZ(value, value_if_null)

 

[maw230]

I have used the Nz Function as follows but it still isnt working still not giving me the result of 0
=Nz(Sum(IIf(([Handling]>#00:02:00# And [Going]="YES"),0)))
Have i used it incorrectly?

If you want it to show 0 for Nulls use a 0 and not a 1 at the end.

 

[pr2-eugin]

I think this is all you need !

Sum(IIf(([Handling]>#00:02:00# And [Going]="YES"), 1[COLOR=Red][B], 0)[/B][/COLOR])

 

[pbaldy]

I guess my services are no longer needed here.