Tags: access, base, database, date, entered, expiry, hen, ifthere, inform, mark, memberships, microsoft, mysql, notification, oracle, record, recording, sql
Notification of expiry date, entered on data base
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.
Leave a comment...
- 1 Comments
- 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:
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]))
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mick LeP" <MickLeP.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message
> 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
> date has passed.#1; Thu, 05 Jun 2008 09:21:00 GMT