Crosstab Query - Looking to force it to show "0

[eholtman]

I am running a Crosstab Query by the months for different Types of Products. If there was not products within that month the value is on the crosstab is coming up "blank". I dont like the look of that so is there a way to force the crosstab to show "0" for the count.

My VSB knowledge is below par.

 

[KenHigg]

I think if you 'wrap' all of the fields with a nz() in the original query it will replace nulls with '0's...

 

[CraigDolphin]

And if that fails, try something like:

IIF(Sum([ValueFieldNameHere]) & "" = "",0,Sum([ValueFieldNameHere]))

...assuming you're summing the results. If you're using count or something else then replcae the sum parts with the relevant aggregate function. You'll likely need to use 'Expression' in the Total row of the query builder for the field.