getting several hundred n-counts

J

johnny vino

I have a db with about 7000 student records. I need to get the total
students for each course section (300-400). What's the quickest way to do
that?
 
A

Allllen

probably subtotals

1 - sort them by course section. THis is important

2 - data > subtotals
At each change in COURSE SECTION
use function COUNT
add subtotal to COURSE SECTION

3 - it will insert the subtotals. On the left hand side you can now choose
the grouping level 2, and it will just tell you how many there were in each
group.
 
Top