Sergey,

The query now works great. But I want to be able to cross tab it, e.g.

Queue Name        I      H      M     O        
UNASSIGNED        0      0      0     1000   
CORRECTION        0      0      0     2000  
BILLER            0      0      0     10

where I, H, M and O are departments. However, here is a little problem. Our Queue Names table has only certain departments. I'd like to show all departments as my field names. I ran FastXTab against the resulting cursor and get the result I showed [except for the little problem with O department that was replaced with _]. What would be the easiest way to add other departments to the resulting cursor?

Thanks.