Re: Null values on crosstab query

set the control source to =nz([FieldName],0)

But why?. Most reports I have seen based on crosstab look better with blanks
instead of 0 plus you can tell which have values that happen to sum to 0.

"Nobby" <shaneclark@xxxxxxxxxxxxx> wrote in message
news:1185793778.085484.70110@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On a crosstab query, I often produce reports that show Counts of
values. the problem that I have is that where there are no counts, no
values are returned i.e. there are blank cells.

Is there an easy way in which to automatically replace these null
values with a zero?

Many thanks.



.

Relevant Pages

  • RE: Adding Crosstab Query Reports to Subreports
    ... Crosstab columns are quite often dynamic. ... the Column Headings property of the crosstab query. ... "Public Schools" wrote: ... I have created 3 crosstab query reports (Division pass rates by course, ...
    (microsoft.public.access.reports)
  • Re: Reverse Engineer Reports in Access DB
    ... Controls on the Report obtain their data from the Control Source specified ... directly or in a user-defined function), you can see that a visual ... If the free documentation aids to which Duane referred at Jeff Conrad's site ... but it creates extensive reports (so ...
    (microsoft.public.access.reports)
  • Re: Getting #Error in report field
    ... In reports, if you wish to use a field's value when the ... field is in the report's recordsource, you must do one of the following ... > The odd thing is if I put a hidden field on the screen callex txtEmail with a control source of Email and put txtEmail in the above control source, ...
    (microsoft.public.access.reports)
  • Re: Upper case for control source
    ... Tips for Access users - http://allenbrowne.com/tips.html ... You are right the control was not a label box but a text box. ... on reports there are no event procedures for text ... is a label you cannot set its Control Source to: ...
    (microsoft.public.access.reports)
  • Re: pigeon hole report
    ... There are also some reports in the calendar reports and corp tech ... > Access Database, expressly Crosstab Queries. ... >> plan information for a specific pigeon concatenated together. ... >> concatenate function comes from ...
    (microsoft.public.access.reports)