Age from DOB

[Guest]

I have the years set up and it works, now Ii want to add how many Months and
Days to the next birthday with labels. ETC. 35yrs, 8 months, 6 days. this
will be in a form. can you please help?

 

[fredg]

I have the years set up and it works, now Ii want to add how many Months and
Days to the next birthday with labels. ETC. 35yrs, 8 months, 6 days. this
will be in a form. can you please help?

Check "A More Complete DateDiff Function" at
http://www.accessmvp.com/djsteele/Diff2Dates.html