Blanks to zero

[AccessQuestions via AccessMonster.com]

I have a report that displays values comparing Monthly and Quartly value to
yearly values. Of Course when yearly values show up compared to monthly
values; the monthly value may be zero compared to the yearly value may be 10.
The problem with my report is that the zero value for the months show as
blanks instead of zero's, how to I get "0" to show up rather then blanks?

 

[Duane Hookom]

I would probably use the Format property of the text boxes to display a 0
where the value is null. This doesn't do anything to mess up your control
source. Check Help on FORMAT PROPERTY NUMERIC to find the specifics.

Others may suggest you use Nz([Your Field],0)