calculate somebodies age on a certain date

[Guest]

I am do a database for my cricket club. I am trying to group all those that
were under 11 , under 12 etc on a certain date and i am having difficulties.
This is my first database so I am a complete novice any help would be greatly
appreciated

 

[Guest]

You'll find various means of calculating age at the following link:


http://www.mvps.org/access/datetime/date0001.htm


If you use the Age function (just copy and paste it into any standard module
in the database), assuming you have dates of birth in the table, you can
return each member's age, e.g. on 1 January this year with a query such as:

SELECT Member, DoB, Age(DoB, #01/01/2007#) As CurrentAge
FROM Members
ORDER BY Age(DoB, #01/01/2007#);

Ken Sheridan
Stafford, England