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
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