Crosstab query to show zero totals

  • Thread starter Thread starter Ngan Bui
  • Start date Start date
N

Ngan Bui

I have a crosstab query below:

CompType Total ASC ASI
Booking 82 80 2
Cancel 2 1 1
Conduct 32 20 23

In this sample, Urgent type was never selected so it
doesn't show up on the crosstab. Is there a way to have
urgent show up and have the total be 0? I want the
crosstab to show all the CompTypes, even tho the Total
could be zero (never selected).

Thanks.
 
You would need to include your table of CompTypes (one record per CompType).
Double click the join line and select to include all the records from the
CompType table. If this doesn't work, then you can create a new query based
on your crosstab and a table with all unique CompTypes. Again, double-click
the join to include all the CompTypes.
 
Back
Top