Output Age

[Dave]

Does anyone know how to output the age in years of
someone as of today with thier DOB in the mm/dd/yyyy
format. I'm pretty sure there's probably a function I
just don't know what it is. Any help would be
appreciated.

Thank You
Dave

 

[Duane Hookom]

Check this page http://www.mvps.org/access/datetime/date0001.htm.
One expression suggested on the page is:
Age=DateDiff("yyyy", [Bdate], Now())+ _
Int( Format(now(), "mmdd") < Format( [Bdate], "mmdd") )