Other than a query is there a way to count distinct records

I need to give counts of students in various different groups (FR/SO, JR, SR that have enrolled and have not enrolled). This count is needed for about 30 awards. I am looking for recommendations.