Show zeros for null in crosstab query

  • Thread starter Thread starter KrispyData
  • Start date Start date
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!
 
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]
 
Back
Top