Re: Groups by Age and Female, male

On Sun, 23 Mar 2008 10:33:54 GMT, "Totte via AccessMonster.com" <u42284@uwe>
wrote:

Okay I will try, in Swedish wrestling the group is change that year he/she is
8, 12, 15 or 17 years old. Here is an exampel from USA Wrestling <<
http://www.usawrestling.org/forms/Weights.pdf>> they have different agegroup
and groupname but the same system as in sweden.

ex, Mark is born 2000-03-20, he is 8 year, and this year 2008-01-01 he become
"Boy younger 8-11", and 2011-03-20 he will be 11 years old and he is still
"Boy younger 8-11".
In 2012-01-01 he will be (12 year during 2012) "Boy older 12-14".

NAME AGE OF YEAR GENDER CATEGORY
Mark 8 (this year) Male Boy younger 8-11
Robin 11 (this year) Male Boy younger 8-11
Viktor 12 (this year) Male Boy older 12-14
Anton 15 (this year) Male Man younger 15-17

I want the CATEGORY to change automatic, ex: between 8-11year he/she is Boy
younger/Girl younger and between 12-14year he/she is Boy older/Girl older.And
so on.....

Storing the fact that Mark is 8 this year is INCORRECT DESIGN, because it
requires that you edit the value in this field every year for every child!

If you instead store the fact that Mark was born in 2000, and Robin was born
in 1997, and Viktor was born in 1996 - by storing their birthdate - then you
can dynamically calculate the category for ANY person at ANY time, by using
DateDiff() to calculate their current age as of the time the query is
executed.
--

John W. Vinson [MVP]
.

Relevant Pages

  • Re: Men are too frightened to give women the compliments they need
    ... I don't agree with your premise, Mark. ... you've argued that my wife isn't a slave but rather ... opportunity for a better life, for drugery with you for the time ... when I was younger, and had several offers of matrimony. ...
    (soc.men)
  • Re: If Obama is from Kenya not eligible for pres
    ... Mark C..you're a dufus and a f--king idiot. ... John McCain was born in Panama Canal. ... He doesn't fucking have to, ...
    (alt.politics)
  • Re: Jewish Attitudes to Dresden Bombing
    ... They left Germany before WWII. ... The younger one (I think he had been born in 1925) ...
    (soc.culture.jewish.moderated)
  • Re: Jewish Attitudes to Dresden Bombing
    ... They left Germany before WWII. ... The younger one (I think he had been born in 1925) ... visited Dresden after the end of the Cold War. ...
    (soc.culture.jewish.moderated)
  • Re: Wiltshire geography
    ... But her marriage record indicates she was born in ... Is there a place in Wiltshire that might sound like "Folkston"? ... there is no reason at all why place of birth has to be the place where one's 'younger years' were spent. ... The OP acknowledges that it might have been Folkestone in Kent, but it is perfectly reasonable to ask someone with local knowledge if there is anywhere in Wiltshire that sounds similar. ...
    (soc.genealogy.britain)