Sorry, you're right, I didn't explain very well.  I'll give you some
background and a better explanation of what I need from the database.  This
is a database I've used for years but recently I was given the task to notify
instructors whether or not their students have provided required
documentation to train in local medical facilities.  

These Requirements include having a current physical, health history, CPR
certification, TB test, MMR, HIPPA training, etc.

My database looks like this:  one table with many students.  I have a field
called Status (graduate, current, prospective, dropped, failed, etc.)  Each
student marked Current (in the Status field) must show proof of having met
Requirements.

What I want to do is query for Current students, then fill in a form (or
whatever) for each student that lists all the requirements (some requirements
will have a check box, some will have a date) they meet.

Then, I want to print a report that lists Current students that do not meet
all of the requirements and specifically WHICH requirements are not met for
that student.

I think I've explained better, if not let me know.  If it's better/quicker
to discuss this over the phone, I can arrange to be here in the evening and
the school can pick up the tab for the call.  Thanks for your help.