Zero Attendance Report

[sfmacchick]

I have an attendance database with two tables, Student Info & Attendance. Student Info has just that, one record per student with a key field. Attendance has one record per class attended for each student. I have a script driven report that finds for the desired month, then shows the days and total of classes each person has taken. That part is working.

The issue is that I now need to pull out the students that have ZERO classes attended for each month. Should be simple. I'm losing my mind.

I've tried various sub summary reports and portal configurations, but the best I can get is a listing by student with the months they attended at least once, not a short list of non-attending students.

Thanks.

[Søren Dyhr]

Ah - left outer join is it called, take a look at this:

http://www.fmforums.com/forum/showtopic.php?tid/211362/

--sd