[Download-List] Count Records in Group

John Davis davisj at marietta.edu
Mon Sep 29 12:44:49 EDT 2008


Try Cedarville's TALLY command.  For example, to count all the various  
classifications, then select the students for the term and then tally.

SELECT STUDENT.TERMS WITH STTR.TERM = '08/FL' ....
TALLY STUDENT.TERMS STTR.CLASS

The output would be similar to the following:

TALLY OF "STTR.CLASS" FOR FILE STUDENT.TERMS
09/29/08 12:44:16PM


NULL               3
AB                13
CE               102
FF               412
FR                65
HS                 4
JR               323
MC                22
ME                41
ML                 1
MP                20
ND                 6
SO               404
SR               291

1707 SOURCE KEYS READ FROM SELECT LIST
1707 SOURCE RECORDS INCLUDED ON THE REPORT
0 SOURCE RECORDS EXCLUDED FROM THE REPORT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  John R. Davis, CIO           E-mail: davisj at marietta.edu
  Information Technology       http://www.marietta.edu/~davisj
  Marietta College
  215 5th St                   Voice: (740) 376-4390
  Marietta, OH  45750          Fax:   (740) 376-4812
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


Quoting Brian Pollitt <bpollitt at dacc.edu>:

> Hi everyone,
>
> I was wondering if there's a way to count the number of records in a
> group, and also get the total count of records for the entire list?
>
> Thanks so much for the help!
>
> -- 
> Brian Pollitt
> Programmer/Database Administrator
> Administrative Data Systems
> Danville Area Community College
> (217)443-8854



----------------------------------------------------------------
This message was sent using Marietta College WebMail.





More information about the download-list mailing list