AnsweredAssumed Answered

Find non reporters

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



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.