Notification of expiry date, entered on data base

[Guest]

I'm using an Access database for recording memberships, I was wondering if
there was anyway i could either inform me or mark the record hen the expiry
date has passed.

 

[Allen Browne]

Over the years, one person will have many memberships. You need a table of
members (with a MemberID primary key), and a related table of memberships.

The Membership table will have fields:
MembershipID AutoNumber
MemberID Number which member this is.
MemberDate Date/Time when this membership begins.

Now you can show when the member is due by creating a query into the Member
table, and typing an expression into the Field row. Something like this:
MembershipDue: DateAdd("yyyy", 1, DMax("MemberDate", "Membership",
"MemberID = " & [MemberID]))