Query to Calculate age of a person

  • Thread starter s b via AccessMonster.com
  • Start date

S

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
 
Ad

Advertisements

A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top