look up GROUP BY and COUNT in BOL
alternatively please provide more details in the form of table create scripts and sample data (if you are not sure on how to do this please ask)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day