Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2011
    Posts
    7

    automatically update club members age group

    Hi all! Could someone help me with this please.



    I have a sports club, it's members are divided into age groups,

    ie. under 10's, under 13's, under 16's and 16+.

    My question - is it possible to program my access db so that it automatically changes an individuals age group on his/her DOB?

    ie. when a 9 year old turns 10 years of age the 'age group' field in the members table would automatically show that he is now in the under 13's age group .

    kind regards,

    Marek

  2. #2
    SteveF is offline Generally AccessAble
    Windows XP Access 2010 32bit
    Join Date
    Nov 2010
    Location
    Fourth Corner
    Posts
    123
    It's certainly possible to do this, but perhaps the age group is not something that should be stored as a value in the database.

    Instead, calculate the age group on an as-needed basis; i.e as part of a query which supplies the data for a form or report.

    If you don't mind sharing some of your data, I could take a look and probably come up with something that would meet your needs.

    Steve

  3. #3
    Join Date
    Mar 2011
    Posts
    7
    Thanks Steve,

    I'm happy to send you what I have but it's pretty rudimentary since I don't yet know what I'm doing. I'm learning Access as I go. I'll send it to you via private message.

    Marek

  4. #4
    SteveF is offline Generally AccessAble
    Windows XP Access 2010 32bit
    Join Date
    Nov 2010
    Location
    Fourth Corner
    Posts
    123
    Marek,

    I received your database, I'll have a look at it.

    One question: in your club, does a participant stay in the same age group where they start for an entire year/term/session (whatever), or do they instantly change age groups on their birthday?

    If you use the year/term/session model, I'll need to know the duration of whatever it is you use.

    Steve

  5. #5
    Join Date
    Mar 2011
    Posts
    7

    automatically update club members age group

    Steve,

    They instantly change age groups on their birthday, and are also automatically down-graded two or three judo grades at the same time.

    Marek.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Automatically update field
    By Top Fuel Friday in forum Forms
    Replies: 3
    Last Post: 02-12-2011, 12:14 PM
  2. Need help designing a database for a club
    By tsuchong in forum Database Design
    Replies: 5
    Last Post: 01-31-2011, 12:39 AM
  3. How to update fields automatically
    By kosan in forum Forms
    Replies: 1
    Last Post: 09-10-2010, 04:49 PM
  4. Automatically update datasheet
    By tammiep in forum Forms
    Replies: 1
    Last Post: 08-17-2010, 04:43 PM
  5. How to Automatically Group
    By SSgtJ in forum Reports
    Replies: 3
    Last Post: 05-17-2010, 12:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums