>Larry - that's the direction I was heading - just aggravating that I have to group by everything I want to select
See if ROLLUP or CUBE can help you (if you are using SQL 7 or latest).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com