would like to have zeros instead of a null value for crosstab queries

[AshikHusein]

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.

 

[Travis]

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)

 

[AshikHusein]

That works!!

That works beautifully!! Thanks.

 

[Brahim]

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

 

[AshikHusein]

Did you change the control name

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

 

[Brahim]

Thanks, now it works