show "0" counts in crosstab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I currently have several crosstabs, Querys & Forms.

What I need to find out is how to get the zero counts to show. I am trying
to add up people assign to a phone skill at what priority they are assigned.
EX. I'm showing:

Skill priority 1 priority 2 etc............
80 6 1
82 5
83 1

I know that the blanks are 0s and that 6 people are assigned as priority
1..., but what I am missing is skill 81 with no one at all assigned to it.
That's some very important information.
 
PS. I can't just list the full sequence, I have a lot of gaps in the
numbering. I need allof the listed skills to show.
 
It is possible that you should change a join to include all records from a
table/query rather than only records where there is a match.
 
Back
Top