469,920 Members | 2,366 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,920 developers. It's quick & easy.

Null values on crosstab query

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.

Jul 30 '07 #1
5 7740
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.

Jul 30 '07 #2
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.

Jul 30 '07 #3
Set the Default Value for the field in the table to 0
Jul 30 '07 #4
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.

Jul 30 '07 #5
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.
Jul 31 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Matthew Wells | last post: by
2 posts views Thread by Sherman H. | last post: by
4 posts views Thread by Judy | last post: by
12 posts views Thread by jkearns | last post: by
4 posts views Thread by greg | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.