3 Replies Latest reply on Jan 12, 2010 10:05 AM by comment_1

    Limiting records by the value of a "sum field"

    tzaluski

      Title

      Limiting records by the value of a "sum field"

      Post

      Objective:

      creating attendance discipline letters for any student that has more than 7 total Day codes (day absent/day late/day left early) within a period of time.

       

      Current scenario:

      I have a day code summary report and an Attendance Letter, both containing the sum_daycodes or Total_records field. Both reports are

      subsummary based on IDstudent and work fine with a found set.

       

      Problem:

      I can't seem to find a way to limit the records in either of these reports/letters to only the students with more than 7 total codes/records.