Calculating current age in years and months

[MarionD]

Hi All,
I know this question has been asked before, but my search doesn't give me what I need. Hope someone can help.

I am trying to calculate the age on the day the report is printed in Years and months ( and display it thus) in a report.

e.g. 6 years 4 months.
Thanks for any help
M

 

[Brianwarnock]

I think but am not sure that Pat's DB in this thread has a sample

http://www.access-programmers.co.uk/forums/showthread.php?t=238821

Brian

 

[MarionD]

Thanks so much and thanks to Pat as well!