How to calculate diffrence between two dates

[Vianny]

In Access expressions, how can I calculate the difference between two dates
in years, months and days?

 

[Stuart McCall]

In Access expressions, how can I calculate the difference between two
dates
in years, months and days?

Look up the DateDiff function in help. It does precisely what you want.

 

[BruceM via AccessMonster.com]

Unless something has changed in Access 2007, DateDiff will return one time
interval (years OR months OR days), but not a combination.

Here is a link to code for calculating age in years, months, and days (the
detailed version at the bottome of the page). It can be adapted to work with
the start date and end date of your choice (rather than DOB and the current
date).
http://www.mvps.org/access/datetime/date0001.htm