Showing zero instead of blank

  • Thread starter Thread starter Gringarlow
  • Start date Start date
G

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.
 
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.
Click to expand...

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.
 
I tried that , it changes all of the values to -0.??
This is a number field with no decimals
 
Back
Top