I'm not an expert in MS Access....the reason being that MS excel pivot tables are much easier to deal with in my opinion.
Email me from my 360 page if you'd like instructions on how to create a pivot table. It does exactly what you need done.

__________________
Yahoo!