[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