Showing zero instead of blank

[Gringarlow]

Access 2003 -
I have a report that I would like to show the value 0 (zero ) instead of
blanks
The source query does not have data for the items that show as blanks
The query sums up items by dates, and if nothing happened on a specific
date, there is no data for that dat, thus a blank appears on the report. I
would like to show a zero, so no one asks me why the date has no data.

 

[fredg]

Access 2003 -
I have a report that I would like to show the value 0 (zero ) instead of
blanks
The source query does not have data for the items that show as blanks
The query sums up items by dates, and if nothing happened on a specific
date, there is no data for that dat, thus a blank appears on the report. I
would like to show a zero, so no one asks me why the date has no data.

This is a Currency field (dollars and cents)?
Set the Format property of the control to:

#,##0.00;-#,##0.00;0.00;\0


This is a Number field (no decimals)?
#,-#,\0;\0

Look up format Property + Number and Currency datatypes
to learn why this works.

 

[Gringarlow]

I tried that , it changes all of the values to -0.??
This is a number field with no decimals