Linking Crosstab Queries

[Guest]

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

 

[Michel Walsh]

With Jet? Have a table with all the possible rows, say it is t1. Then, use
it as preserved side of outer join with each single xtab:



SELECT *
FROM (((t1 LEFT JOIN xt1 ON t1.name = xt1.name)
LEFT JOIN xt2 ON t1.name=xt2.name)
LEFT JOIN xt3 ON t1.name =xt3.name)
LEFT JOIN xt4 ON t1.name = xt4.name




Hoping it may help,
Vanderghast, Access MVP