AnsweredAssumed Answered

Limiting records by the value of a "sum field"

Question asked by tzaluski on Jan 12, 2010
Latest reply on Jan 12, 2010 by comment_1

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.

 

Outcomes