8 Replies Latest reply on Jul 3, 2017 9:44 AM by gofmp15

    Find non reporters

    MarkPage_1

      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