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@dsl.pipex.comwrote in message
news:1185793778.085484.70110@b79g2000hse.googlegro ups.com...
Quote:
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.
>
