jpipes,
Thanks for your help, I'm getting an error on the statement:
Incorrect syntax near the keyword 'GROUP'.
It appears that it is choking on the group last group by portion on the page. I've tried fixing it, but I have yet to figur out why it's doing that. Do you know?
Thanks for the help!