To calculate length of years, months and days in Access 2003, you need
to create a function. The function will use a begin date and an end date
to return a value in the units you have specified. Use the Age()
function to calculate an age in years for a begin date as the person’s
date of birth and the end date of your choice. The current date is the
most commonly used end date, although you may desire to use a date of
death as the end date or another date that makes sense to your task.
Input the “StartDate” and use varAge = DateDiff(“yyyy”, varBirthDate,
Now) if you want the current date as the end date.