Sounds like what you want is what used to be referred to as a Cross Tab, but now is referred to as a Pivot Table. Check out the pivot Table wizard or, as Dave Frakenbach suggested, the cross tab generator.