Force Rows on a Crosstab Query

  • Thread starter Alex T. Martínez
  • Start date
A

Alex T. Martínez

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
 
A

Arvin Meyer [MVP]

Run a preliminary query which forces all nulls to zeros:

NZ([MyField],0)
 

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

Top