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