Query to Calculate age of a person

[s b via AccessMonster.com]

Hi

Wonder if you could help with the following, i need to display in a query the
ages of people but the age range categories are already defined.

For example, a person would be aged 8 and would fall in the following age
ranges 01/09/1996 to 31/08/1997 he or she would have the date of birth of
08/10/1996.

Another example is a person with the following date of birth 09/10/1995 would
be aged 9 and would fall in the already defined age range of 01/09/1995 to
31/08/1996.

I have to work towards the already defined age range categories, the above
will not display a true reflection of a persons age, but the work i need to
carry out will look at individuals at a specfic time of year.

Thanks

SB

 

[Allen Browne]

See:
http://allenbrowne.com/func-08.html
The article explains how to calculate the age in whole years as of any date,
and comments on why several of the ideas people often try don't work as
expected.

From your example, it looks like you live in a d/m/y country, so you might
also benefit from:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html
This article explains how to solve the 3 cases where Access commonly
misunderstands our date format.