Show zeros for null in crosstab query

K

KrispyData

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!
 
D

Douglas J. Steele

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]
 
Top