I have created a simple database that allows the administrative
assistant here at my school to track teacher attendance. Fields
include "Teacher" "Absense Type", and "Date". A new record is created
to record each absense, and I have created custom value lists including
all of the teachers (and absense types).

I need to create some sort of script / algorithm to pull up a "perfect
attendance" report. The system works great to track absenses, but I
need to figure out how to do the inverse. Ideally, I want a variable
associated with each Teacher that counts the number of absenses, but
since individual records represent absenses (not teachers), I don't see
how to do this. Any ideas on how to use a script or new layout to do
this?
Thanks,
Jon

In article <1118955316.249463.34810 (AT) g47g2000cwa (DOT) googlegroups.com>,
jstoper (AT) hotmail (DOT) com says...
If this is a single table tracking only absenses you're hooped. The
teachers who haven't had any absenses don't even exist in the system. So
its logically impossible that you could generate a report of them.

The solution is to add a 2nd table containing teachers. Create one
record for each teacher, and define a relationship between it and
absenses.

Then its a simple matter to find all teacher records with at least one
related absense record, and Invert the found set.

Good luck.