Thank you very much for that simple but effective SQL. I can see why you have so many posts....... 🙂

Only thing is that this only counts the category/subcategory totals and...

I tried your version GS but got no results. Obviously I am inexperienced in these matters.

I have decided to attach two tab delimited files for the original data from the...

Thanks for your reply GS

I will try it out soon but have not had a chance yet. You have been most helpfull unlike some others here.

Wow thansk for the fast replies all.

Unfortunatley I enherited this DB and am stuck with it. My research did indicate nested would be better but no option to redo it.