calculate age from DOB then display and manipulate those values?

[Guest]

I need to calculate the age from the DOB field, and be able to display and
use those values in queries to do averages and ranges in reports. I retrieved
the expression for calculating age; ( =DateDiff ("yyyy", [Birthdate], Now(
) ) + Int( Format (now( ), "mmdd") <Format ( [Birthdate], "mmdd) ) )
*the outermost parenthesis are mine. However, that solution only seems to
work on a form. I am unable to see those values anywhere else, much less
manipulate them. Please help. I am using MS Access 2000. The database
contains approx 400 records.

 

[Allen Browne]

See:
http://allenbrowne.com/func-08.html

The article explains some things that are commonly used that don't work, and
contains a function to calculate the age at any date.

 

[Mike Painter]

I need to calculate the age from the DOB field, and be able to
display and use those values in queries to do averages and ranges in
reports. I retrieved the expression for calculating age; (
=DateDiff ("yyyy", [Birthdate], Now( ) ) + Int( Format (now( ),
"mmdd") <Format ( [Birthdate], "mmdd) ) ) *the outermost
parenthesis are mine. However, that solution only seems to work on a
form. I am unable to see those values anywhere else, much less
manipulate them. Please help. I am using MS Access 2000. The database
contains approx 400 records.

Base your forms and reports on a query and use the calculated value
AgeateDiff ("yyyy", [Birthdate], Now( ) ) + Int( Format (now( ),

"mmdd") <Format ( [Birthdate], "mmdd) )

It will appear as just another field.