Here's an example using the Northwind Employees table... SELECT Employees.HireDate, DateDiff("m",[HireDate],Now()) AS time_in_Service FROM Employees;