Year Help!!!!

[sysop470]

Hi..

I need some help how can i get all persons that age is equal to 25 years till the end of this year??

any clue please??

 

[mhartman]

Hello:
Make a query of your table. In the table add an extra column and put the following in FIELD header:
'
Expr1: Year([birthdate])
'
In the criteria section for that column, enter =25
This will return all records that the birth year is equal to 25
'
Regards
Mark

 

[Rickster57]

Age

I may be misundersatnding this but it sounds like your saying "show me everyone that will still be 25" by the end of the year.
Use a query:

expr1:datediff("yyyy",[birthdate],#12/31/2006#)
in this criteria place 25

Hope this helps