We are tracking daily student tardies at our middle school and are consequencing students who have 4 or more tardies in a 6-week period. I have created a related table to pull in student tardies each day. I have created a sub-summary with a summary field of Tardy Totals. It is correctly calculating total number of for each student when in "Preview," but I can't figure out how to do a Find in this field for students who have 4 or more tardies. What am I doing wrong? I appreciate any insight you can give me!

Actually, an unstored calculation may be acceptable and is simpler to set up. If you find that it is too slow, you can then try using alternative methods that take a bit more work but produce a stored value.

If you have this relationship:

Students::__pkStudentID = Tardies::_fkStudentID

A calculation field in Students can be defined as Count ( Tardies::_fkStudentID ) is an unstored but searchable and sortable field.

One way to get a stored count is to set up a script that creates a new record in Tardies to log the student tardy and that then adds 1 to a number field in Students to show the current tardy count. You then also need to deduct 1 from this field any time that you delete a record from tardies--say to correct an error or to excuse a tardy.