Crosstab query

  • Thread starter Thread starter Paul Joselow
  • Start date Start date
P

Paul Joselow

I am trying to make a Crosstab query where each column
heading is contained in a field in a row of one table.
The count I want is the number of instances this column
heading occurs in a corresponding field of another table.
The problem is that when I join the tables together, any
columns with a zero count no longer show up. How can I
guarantee that I get all the columns in the column heading
table including the ones with zero count?
I am using design view. I though in SQL view I could
perhaps switch to an OUTER join but Access didn't like
that.
 
You can enter all the possible values into the Column Headings property.
Otherwise I thought I had luck in the past with outer joins.
 
Back
Top