Age from two fields, birthdate and deathdate

[cimoli]

I am looking to add a calculated field into my Access 2003 query. I need to calculate a person age based on a death and birthdate. I would want just a simple rounded age EG age 86 or age 22. Not any decimals.

Is this possible?

Thanks for your help. I am doing this for my family genealogy report for the reunion.

 

[papadba]

Yes, this is possible. . .

How are the columns (bdate, ddate) defined?

 

[dhookom]

I would use the calculation found at MVPS.org/Access.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

Try:

[blue]= DateDiff("yyyy", birthdate, death) + Int(Format(death, "mmdd") < Format(birthdate, "mmdd"))[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]