For crosstab queries, when a sum valuates to zero, it returns a null value. Is there anyway that it can return a zero instead of null because I get these blank spaces in the report obtained from the crosstab which would look better with zeros and not confuse the management who reads these reports. Thanks.

change the control source on the report to :

=Nz([Field Name],0)

Make sure that the Controls name is not the same name as the Control Source Name (Access by default does this)

That works beautifully!! Thanks.:)

Hi,
i have the same problem but unfotunately it's not working, even with nz([field],0)

when i go to inside the report's record source and run it those field contain zero but when i run the report itself the same record show blank (null)


please help me

Did you change the control name to be different then the control source name?

Thanks, now it works ;)