Put a 0 (zero) in an unbound list box based on a query in a report

[Leslie]

I have a report that is based on numerous queries that are calculating
monthly and YTD totals for our Department Manager's monthly report. One of
the fields totals as zero (0) for the month. He would like to see a 0 in
that unbound field rather than it just being left blank. It would be
possible for it to be a different field next month when the report is run.
I'm using Access 2003.

How would I go about doing that?

 

[fredg]

I have a report that is based on numerous queries that are calculating
monthly and YTD totals for our Department Manager's monthly report. One of
the fields totals as zero (0) for the month. He would like to see a 0 in
that unbound field rather than it just being left blank. It would be
possible for it to be a different field next month when the report is run.
I'm using Access 2003.

How would I go about doing that?

Set the Format property of each of those controls to:
#,##0.00;-#,##0.00;0;0

See Access help
Format Property + Number and Currency datatypes