Force Rows on a Crosstab Query

[Guest]

I’m trying to make one report that combines the results of several crosstab
queries. I want all the queries to have the same columns AND rows, so that
the data will match when I put the queries side by side. The problem I’m
having is that some queries don’t have any data on some of the rows, in which
case the crosstab query eliminates the row all together instead of putting
“zeros†in the field. Is there a way to force the crosstab queries to show
all rows even if the values are null? Thanks for the help.

A-Mart

 

[Arvin Meyer [MVP]]

Run a preliminary query which forces all nulls to zeros:

NZ([MyField],0)