Hi. I am writing a query to use in a matrix rpt. I have three ticket types Internal, External, Other and escalate codes 1,2,3. I would like to count the number of tickets but if there are none i would still like the type to display 0. How can this be done? I used an iif statement in the format but something is still not displaying.
getting:
Code1 code3
internal 1 0
other 0 2
would like to see:
code1 code2 code3
internal 1 0 0
external 0 0 0
other 0 0 2
Also, would it be okay to add another table to accomplish this, or do you not have that option? If not then a UNION will be needed with hard coded data...
~bp