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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.