AnsweredAssumed Answered

Find non reporters

Question asked by MarkPage_1 on Jul 3, 2017
Latest reply on Jul 3, 2017 by gofmp15

Hi,

 

I have a group of students. They are all recorded in MstrMem table.

 

All are obliged to send a report each month. The reports are all saved in table "Month". The link is memID, present in both tables.

 

Month consists of several fields including "Year" and "Month". So I record for each student year (2017) and month (June). However at the end of each I want to find who has not yet reported, and send them an email to remind them. Clearly if they haven't yet reported for June 2017 there isn't a record. So how do I find non entries?

 

Bit baffled by this. I suspect I need to do a find on MstrMem table looking for criteria recorded in two search fields (Year and Month).

 

Any help or pointers would be gratefully received.

 

Cheers

 

Mark

Outcomes