Crosstab query result question

A

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

Duane Hookom

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