I want to run this query which works but I have members in the S_Members_Table that are Life members and Honorary Members
i.e the fields are HONORARY MEMBER; HONORARY VP and LIFE MEMBER.
These members never become expired so I want to run the query but not include them so in effect they do not become marked as expired. How can I change this query to accommodate this?
UPDATE S_Members_Table INNER JOIN S_Payments_Table ON S_Members_Table.MemberID = S_Payments_Table.MemberID SET S_Members_Table.Expired = "UPDATE S_Members_Table SET Expired"=True
WHERE (((S_Payments_Table.PaymentDate)<DateSerial(Year(D ate())-IIf(Month(Date())<7,1,0),7,1)));