General discussion
March 20, 2003 at 07:44 PM
laurie j

How do you calculate ages in Access 2000

by laurie j . Updated 23 years, 6 months ago

I have a Date of Birth field in a form named “DOB” and would like to have a Text Box next to it that calculates the age using the =Date(), Today or =Now() function. Is there a clever calculation that takes into account leap years adn also returns years and months instead of e.g. 82.89?

The calculation I have at present entered in the properties of the text Box is:

“=([now]-[dob])/365”.

This returns a nearly answer of 83.89 for a DOB of 21/5/1919. I would like 83 years and 10 months (ignoring left over weeks and days if there are any.)

Is this possible in Access 2000?

This discussion is locked

All Comments