By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,850 Members | 972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,850 IT Pros & Developers. It's quick & easy.

Null values on crosstab query

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a
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

P: n/a
Set the Default Value for the field in the table to 0
Jul 30 '07 #4

P: n/a
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

P: n/a
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.