Hi, I have a table of employees' history of start and term dates. Start and Term Dates constantly changes so there will be several records attached to the employee. I need to create a query listing the current employee who is working and another one listing employees who are no longer on assignment. How do I extract just the most recent dates and ensure that there are no duplicate names in both list? Version: Access 2003, Professional Appreciate the help, Thanks!