Crosstab query result question

[+Andrew]

A crosstab query only shows results when the column and
row headings match, I want to have "n/a" or a "0" (zero)
printed when there is no match, hence no result.
Thanks. Andrew

 

[Guest]

use the Nz function or the IIF function.

 

[Duane Hookom]

You can set your Value to something like:
TheValue:Val(Sum(Nz([YourField],0)))