Calculating Age in years from birth date

[Guest]

Access, is there some way I can use a Birth Date field and the current date
to calculate age in years? Are there Expressions that will allow this to be
done in the Criteria row of a query? Can the current date be read directly
from the computer?
Thanks

 

[Dirk Goldgar]

Access, is there some way I can use a Birth Date field and the
current date to calculate age in years? Are there Expressions that
will allow this to be done in the Criteria row of a query? Can the
current date be read directly from the computer?

Answered in your previous thread.