Re: Null values on crosstab query

Set the Default Value for the field in the table 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.



.