Membership

Queries

The questions this database answers, saved under a name. Open one to see its answer, or its design to see how it is built and change it.

Renewals due

Active members who have a renewal date, the soonest first, with their name, e-mail and membership type. Only renewals due in the next 30 days, or already past, with the days left (below nought when overdue). Members who have left (Active unticked) and members with no date are left out. Those at the top whose date has passed are overdue.

From Members. Shows Renewal Due, Days Left, First Name, Last Name, E-mail, Membership Type.

Calculated: Days Left is DateDiff("d", Date(), [Renewal Due]).

Only where Renewal Due Is Not Null and Days Left <= 30 and Active = Yes.

Forms

Every table has a form of the same name: Members, Payments. A form shows one record at a time and adds new ones. A field that points at another table is a list of that table's records, and the records that point at this one are listed below it.

Reports

Pages to print or save as a PDF, laid out from a query or a table.

Payments by member

Each member's payments by the day they were paid, with what each was for and its amount, and the total for each member and for everyone. Use it for the treasurer's report or to answer a member who asks what they have paid.

From the table Payments, a group for each Member: Paid on, For, Amount, with the total of Amount.