Showing zero instead of blank

From: Gringarlow <Gringarlow@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 18 Sep 2008 11:54:10 -0700

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.

.

Follow-Ups:
- Re: Showing zero instead of blank
  - From: Chuck
- Re: Showing zero instead of blank
  - From: fredg

Prev by Date: Re: Report in Access97
Next by Date: Re: Showing zero instead of blank
Previous by thread: repeat a column onto another page
Next by thread: Re: Showing zero instead of blank
Index(es):
- Date
- Thread

Relevant Pages

Re: Showing zero instead of blank
... The source query does not have data for the items that show as blanks ... This is a Number field (no decimals)? ... Look up format Property + Number and Currency datatypes ...
(microsoft.public.access.reports)
Re: Showing zero instead of blank
... The source query does not have data for the items that show as blanks ... This is a Currency field? ... Look up format Property + Number and Currency datatypes ...
(microsoft.public.access.reports)
Re: Showing zero instead of blank
... The source query does not have data for the items that show as blanks ... date, there is no data for that dat, thus a blank appears on the report. ... I believe that showing zero when there is no data is ...
(microsoft.public.access.reports)