Can I display numeric zero values in crosstab query reports?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using a report bound to a crosstab query, I would like to view numeric zero
values within a 'Total: Count' field. My intent is to use the same type of
format report when count values may vary during specific time periods (i.e.:
# of events during specific start and stop dates). At present, when my data
changes and I have zero events, the current format of the report bound to
this query returns an error stating that it does not recognize a field which
exists in the present format of the report - this I understand: since there
is no data to be 'counted" there is no column header generated and thus an
unrecognized field, BUT I would like to keep the column header and report a
'ZERO' for that given event within that specific time period even though
there is nothing to 'count'. Is there any way to accomplish this magic?
 
You can enter all of your potential column headings into the Column Headings
property of the crosstab query.

To get zeros rather than nulls, you can use a value column of something
like:
Val(Nz(Count([YourField]),0))
 
Thank You! You have been VERY helpful!!

Duane Hookom said:
You can enter all of your potential column headings into the Column Headings
property of the crosstab query.

To get zeros rather than nulls, you can use a value column of something
like:
Val(Nz(Count([YourField]),0))

--
Duane Hookom
MS Access MVP

Stan_B said:
Using a report bound to a crosstab query, I would like to view numeric
zero
values within a 'Total: Count' field. My intent is to use the same type
of
format report when count values may vary during specific time periods
(i.e.:
# of events during specific start and stop dates). At present, when my
data
changes and I have zero events, the current format of the report bound to
this query returns an error stating that it does not recognize a field
which
exists in the present format of the report - this I understand: since
there
is no data to be 'counted" there is no column header generated and thus an
unrecognized field, BUT I would like to keep the column header and report
a
'ZERO' for that given event within that specific time period even though
there is nothing to 'count'. Is there any way to accomplish this magic?
Click to expand...
Click to expand...
 
Back
Top