Sikh Philosophy Network - View Single Post

#1 (**permalink**) 28-Jul-2006, 08:32 AM

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12790-query-duplicate-records-and-dates.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12790

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!