You can create a query into this table.
In the Criteria row under the Active field, enter:
In the Criteria row under the date field, enter:
<= DateAdd("d", 60, Date())
Note that this is not an optimal structure. I suspect you need a related
table of membership details, where a record is added each time the member
pays their dues. Then next time they are due would then be calculated from
their most recent date in this table by using a Totals query (Totals on View
menu in query design.)
Use SendObject to send the email. There's an argument for the BCC.
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://www.yqcomputer.com/
Reply to group, rather than allenbrowne at mvps dot org.