AnsweredAssumed Answered

Identifying members whose membership has lapsed

Question asked by larryw on Mar 18, 2016
Latest reply on Mar 24, 2016 by

I have a membership database where the Member table is one-to-many related to the Dues table. I want to identify those members who were members last period but who have not yet renewed this period and send them an email reminder.


The Dues table contain the DuesPeriod field, which holds the membership year. Though likely not relevant, membership periods start on even numbered years and run for 2 years, so the DuesPeriod field will contain numbers like 2010, 2012, 2014, 2016.


The query is easily expressed in SQL or as sets: { return the set of members such that there exists is at least one Dues record for that member with DuesPeriod = 2014 and there does not exist a Dues record for that member with DuesPeriod = 2016}.