Hi GSquared,

It looks like that did the trick. Thank you very much for your help.

Regards,

tom

Hi John,

I tried your code but It still only returns the months only if there are time off requests for the month. What am I doing wrong?

SELECT ...

Hi All,

Thanks for the quick response! Jack I think that is exactly what I need. I will give it a try.

Thanks again.

tom

Thanks James for your feedback.  I will have to investigate clustering and partitioning options that you  mentioned.

-tom