QUERY Results

[Pilot0129]

I need an answer for the length of a person's life using [DOB] (Date of
birth) and [DOD] (Date of Death). The answer needs to be in the form of
years, months, days.
The intent is to give the answer so the person knows to the day how long
that person lived.

 

[BruceM]

This may help:
http://www.accessmvp.com/djsteele/Diff2Dates.html

You can probably leave out the parts dealing with hours, minutes, and
seconds, although it is simpler simply not to use those options.