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.