calculating number of years in job

[lakshmi_pili]

I have a table with the LName, FName, Rank, Date_Employed. I need to create a query that will calculate the number of years that the person has been working up to the current day. Is this possible, and if so, how can I do this?

Thank you for your help!

 

[miki]

Select *, DateDiff ("yyyy", [Date_Employed] , Now()) as sum_years
from my_TBL

"yyyy" or "y" i not sure .


[This message has been edited by miki (edited 02-26-2002).]

 

[lakshmi_pili]

Thank you so much!!!!! It worked like a charm!