Show zeros for null in crosstab query

Hi. I created an crosstab query and would like null cells to show a zero. is
there a way to do this in the property sheet or should i use an expression?
Problem is there are many columns in this crosstab and it may be cumbersome
to put an expresssion in each column.

Thanks for any help!

Switch your query to SQL view.

The first line should be something like

Transform Max(SomeField) As [The Value]

Change that to

Transform Nz(Max(SomeField), 0) As [The Value]

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"KrispyData" wrote in message
...
Hi. I created an crosstab query and would like null cells to show a zero.
is
there a way to do this in the property sheet or should i use an
expression?
Problem is there are many columns in this crosstab and it may be
cumbersome
to put an expresssion in each column.

Thanks for any help!