calculate age from DOB then display and manipulate those values?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
dave1127 said:
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.
Click to expand...

Base your forms and reports on a query and use the calculated value
Age:DateDiff ("yyyy", [Birthdate], Now( ) ) + Int( Format (now( ),
"mmdd") <Format ( [Birthdate], "mmdd) )
Click to expand...
It will appear as just another field.
 
Back
Top