Help with Totals

[lpm]

I have a layout which displays accumulated/cumulative absences for students in list view. On each row it shows the absence date, studentname, classname, teachername, absent checkbox (with VL value of 1), absence reason. Example: If a student is absent from 3 classes on one day, he will have three records/rows for that date – same date, same studentname, different classname, different teachername, checkbox checked, same or different absence reason.

Without creating a sub summary report, I’d like to have a field that shows the total absences for each student on another layout in the same table in browse mode. I’ve tried Summary field, Sum, Total, Count, but can’t seem to get it right. Can you help? lpm

WinXP

FM9A