How to map a zero value in a count query

[wsala33]

I created count crosstab query and I would like to map the value 0. I'm inserting the following iff inside the wizard function.

Topic: IIf([QRYWorkflowReport]![Business days open 2] Is Null,0,[QRYWorkflowReport]![Business days open 2])

but when I run the query I get null value's can anyone assist me.

Thanks

 

[KenHigg]

IIf(isnull([QRYWorkflowReport]![Business days open 2]),0,[QRYWorkflowReport]![Business days open 2])

???
kh

 

[wsala33]

thanks

Thank for all you help.