Hi all,

I have a subfile with records like this....

student#    course#   subject#    campus#
9663942K  CA04A     BB10A      BG
9663942K  CA04A     BB01A      CT
9663942K  CA04A     BB02A      CT
9663942K  CA04A     CD08H      OT
9663942K  CA04A     CD10J      OT
9663942K  GH04A     BB89K      BG
9663942K  GH04A    AA01A      CT
9663942K  GH04A    AA06A      CT
9663942K  GH04A    KK04A      OT
..
..ETC..

I am trying to produce a SINGLE record of every student/course combination
that has one or more campuses PER course, with a count of the number of
campuses per course/campus combo.

ie:
student#    course# campus#  NO#
9663942K  CA04A     BG             1
9663942K  CA04A     CT             2
9663942K  CA04A     OT            2
9663942K  GH04A     BG            1
9663942K  GH04A    CT              2
9663942K  GH04A    OT              1
..
..ETC..

I've tried using the following section of QUIZ code....

==========================================
access *tpf5356b

define d-crscmp character*8 = course-version[1:6] + campus-code[1:2]

sort on student-number &
     on d-crscmp &
     on campus-code

set subfile name tpf5356d

define d-crscnt integer*1 = 1

report summary &
     student-number &
     course-version &
     subject-number &
     campus-code &
     d-crscnt subtotal at d-crscmp reset at campus-code
go
==========================================
 ...and all I get is....

student#    course#   campus#   NO#
9663942K  CA04A     BG                1
9663942K  CA04A     CT                 1
9663942K  CA04A     CT                 1
9663942K  CA04A     OT                1
9663942K  CA04A     OT                 1
9663942K  GH04A     BG                1
9663942K  GH04A    CT                 1
9663942K  GH04A    CT                 1
9663942K  GH04A    OT                 1
..
..ETC..

QUESTION: Why is it that the RESET AT CAMPUS-CODE resets it on actually
EVERY record and not at the obvious control-break?

Any help appreciated. Thank you.

Regards,
Fernando Olmos (Analyst Programer @RMIT)