Null values on crosstab query

[Nobby]

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.

[paii, Ron]

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" <sh********@dsl.pipex.comwrote in message
news:11*********************@b79g2000hse.googlegro ups.com...

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.

[RASTUS]

Set the Default Value for the field in the table to 0

"Nobby" <sh********@dsl.pipex.comwrote in message
news:11*********************@b79g2000hse.googlegro ups.com...

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.

[RASTUS]

Set the Default Value for the field in the table to 0

[RASTUS]

Set the Default Value for the field in the table to 0

"Nobby" <sh********@dsl.pipex.comwrote in message
news:11*********************@b79g2000hse.googlegro ups.com...

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.

[Allen Browne]

See:
Crosstab query techniques
at:
http://allenbrowne.com/ser-67.html#DisplayZero

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Nobby" <sh********@dsl.pipex.comwrote in message
news:11*********************@b79g2000hse.googlegro ups.com...

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.