Crosstab query to show zero totals

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.
 
D

Duane Hookom

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.
 

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

query parameter in vba 4
Show zeros for null in crosstab query 1
dcount in a crosstab query 3
crosstab query question. 3
Office 10 Crosstab query with Parameters 0
IIF in Crosstab Expression 0
Interesting query trick...expandable to a crosstab? 5
Crosstab queries, <> and null values 3

Top