Calculate age months, years

[mulberry13]

I have a query that I need to show me ages in months & years from birth. This is what I currently have in the query. How do I add the "months" so it will also calculate that?

Current Age: Year(Now())-Year([Date of Birth])

 

[mulberry13]

Yikes! should I copy your query statement to mine? Thanks for going to all that trouble (of course, it probably took you seconds)!

 

[Phildaburn]

No, just use the formula expressions you want from it.

 

[mulberry13]

Thanks so much for all your help