I have a table of employees' history of start and term dates. Start andReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12790-query-duplicate-records-and-dates.html
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 isReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12790
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!