calculating age

[Nancy]

I have found an expression that can be used in a query to
calculate a person's age based on the date of birth and
the current date. The expression is:

=DateDiff("yyyy", [Birthdate], Now())+ Int( Format(now
(), "mmdd") < Format( [Birthdate], "mmdd") )

The problem is that I need the age in years + months
because I am using it for a dataset of children whose
ages must be calculated exactly. This expression gives
only the age in years. For example, I need "1 year and 2
months."

Can someone please help me modify the expression to get
the remaining months?

Thanks.

 

[Allen Browne]

See Doug Steele's "more complete DateDiff()" at:
http://members.rogers.com/douglas.j.steele/Diff2Dates.html