getting several hundred n-counts
 

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?

getting several hundred n-counts
 

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.
--
Allllen


"johnny vino" wrote:

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?

getting several hundred n-counts
 

Thanks! It's sometimes difficult to find the obvious answer.

"Allllen" wrote:

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.
--
Allllen


"johnny vino" wrote:

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?