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

On Database » Microsoft Access

1,384 words with 1 Comments; publish: Thu, 05 Jun 2008 09:20:00 GMT; (25093.75, « »)

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.

All Comments

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:

      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]))

      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

      news:13E00C12-08E5-4732-AD31-AB12D6B36BDC.ms-access.todaysummary.com.microsoft.com...

      > 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.

      #1; Thu, 05 Jun 2008 09:21:00 GMT