>Select Zone,Class,count(*) From Table1 Group by Zone,Class

Wow... I was expecting some monster SQL for something so complicated. That's nice and simple. I think a lot of our report scanning can be replaced by SQL, so I thought I'd throw one up and see. After I get this one working, I'll see if I can figure out the other ones.

Thanks,

-Michelle