Can access calculate a date of birth in a table? If so how?
Only if you have information in the table (such as the exact age at a
given date, or the longitude of the Sun, Moon and Jupiter at the time
of birth), say.
Perhaps you meant to ask, can you calculate the current age *given*
the date of birth? if so:
Age: DateDiff("yyyy", [DOB], Date()) - IIF(Format([DOB], "mmdd") >
Format(Date(), "mmdd"), 1, 0)
John W. Vinson[MVP]
