>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?

If you don't have long fields, you can use ALTER TABLE.