In access report, I want ot calculate an age in years and months .

[Quechee]

I am designing a report in access and want to display an age in years and
months (ex. 12 yrs 5 months) from a birthdate. I can only find expressions
that will give me either years or months.

 

[Ken Snell [MVP]]

Check out Doug Steele's Diff2Dates fucntion:
http://members.rogers.com/douglas.j.steele/Diff2Dates.html