your suggestion will return all rows where key_field is 'Manager'. I need to be able to return something like:

Key_Field Dept
__________________________
--- Finance
Consultant Trading
--- Sales


Thanks for the thought.