Access 2003 Query return values that have
Posted on 2010-09-10
I am trying to create a query in MS Access to display users with training dates that are going to expire within 1 week (trainings expire a year from previous training date). I am familiar with Oracle's date function and using truncate, however I am having issues finding the equivalent in MS Access.
SELECT Employees.Last_Name, Employees.First_Name, Employees.Dept, Employees.Last_Training_Date, Employees.Notes
WHERE (([Last_Training_Date]< "yyyy", -1, Date()));