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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
Crosstab queries, <> and null values 3
Null to Zero in Crosstab Query 1
Fill Blanks with Zero on CrossTab 4
Crosstab Date Range Problem 3
Sum in a Crosstab query 1
Multiple Parameter Crosstab query filter by form 1
Crosstab Query Problem 2

Back
Top