A
Alex T. MartÃnez
I’m trying to make a report that displays the results of multiple crosstab
queries.
All of the queries have the same rows and columns; only difference is the
criteria. The problem I’m having is that in some of the queries some of the
rows don’t have any values, so Access deletes the row. This makes it
impossible to put the query results side by side (the rows won’t be the same
from one to the other). Is there a way to force a crosstab query to display
all row values, regardless of null values (like you can on columns)? If not,
given that all queries have the same column/row values, would it be possible
to combine all queries into one?
A-Mart
queries.
All of the queries have the same rows and columns; only difference is the
criteria. The problem I’m having is that in some of the queries some of the
rows don’t have any values, so Access deletes the row. This makes it
impossible to put the query results side by side (the rows won’t be the same
from one to the other). Is there a way to force a crosstab query to display
all row values, regardless of null values (like you can on columns)? If not,
given that all queries have the same column/row values, would it be possible
to combine all queries into one?
A-Mart