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

Similar Threads

Append Crosstab Query to Existing Table 0
Create table from a crosstab query 2
Linking Crosstab Queries 0
Linking Crosstab Queries 1
linked tables query 9
Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
Form based on crosstab query 1
report using a subreport based on a crosstab query 5

Top