Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    Barbados
    Posts
    50

    Unhappy Unanswered: Using the Year to decipher the count of Age Range

    Hey all...

    Here's the scenario... I have this form for recording information about a person - name, address, phone #, date of birth. The date of birth field is separated into Month, Day and Year. The month and day field are list down boxes for the user to simply select the items.

    I have to do queries for age ranges using the year to generate a statistical report showing how many people are in the following age range categories: Under 13, 14-19, 20-25, 26-30, 31- 35 and over 35 years old.

    I thought it would have been easy to do by just subtracting the the number of years from the current date. But it doesn't work. Please help.


    BajanElf
    "The extreme always make an impression." - Jeff Hardy

  2. #2
    Join Date
    Feb 2004
    Location
    Dorset UK
    Posts
    147
    Couldnt think how to explain this, so I built a database for you.

    Table has only years in it for demo purpose, query has count, year and age.

    Hope this helps

    Best regards

    Ken.

    PS had my honeymoon in Grenada last December, Its probally the best place in the world..
    Attached Files Attached Files

  3. #3
    Join Date
    Feb 2004
    Location
    Dorset UK
    Posts
    147
    Modified query for your age groups as well !

    Version 2 !!
    Attached Files Attached Files

  4. #4
    Join Date
    Feb 2004
    Location
    Barbados
    Posts
    50
    Thanks, it's working now.

    And yea Grenada is really nice... specially during the summer.

    Lisa
    "The extreme always make an impression." - Jeff Hardy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •