Help query with true and false and date

[Bursal]

I have a membership database with checkboxes for three types of membership and date columns for Date Admitted and Date Renewed. I need a query that will uncheck the checkboxes that have a date before a specified date.

I can get the checkboxes unchecked but I can’t get the date part right.

I would appreciate any assistance. Thanks for reading my post.

 

[JHB]

Show the SQL-string you've.

 

[Bursal]

Thanks JHB for the reply. I revisited the query with a clear head and I have it working.

This was the line that I was having trouble with:
WHERE (((qryMembershipCurrent.Ordinary)=False) AND ((qryMembershipCurrent.Organisational)=False) AND ((qryMembershipCurrent.Associate)=False)) OR (((qryMembershipCurrent.DateAdmitted)>#7/30/2015#)) OR (((qryMembershipCurrent.DateRenewed)>#7/30/2015#));

Thanks again
Bursal