Calculate Time in Service (year, month, day)

[Randell]

I am using Windows 7 and Windows 8 (depending on which computer I am using) with Access 2013.

I want to be able to enter the date a volunteer joined and calculate their Time in Service with the output providing the number of years months and days they have been a volunteer. I have tried DateDiff and have only been able to figure out how many years they have volunteered and not the months and days.

Your help is much appreciated.

[CJ_London]

google 'vba year month days' or similar and you will find a number of solutions. Here's one

http://www.vbaexpress.com/kb/getarticle.php?kb_id=866

[Randell]

I have found several VB examples and am working through them now. Thank you.