Search results

I need help creating a query that creates a "to" value. Have this table: Manr_f, CC, SD, ED Manr_f = employee number CC = Cost Center SD = "from" date ED = should be "to" date based on SD Manr_f,CC, SD, ED 1001,1,6924,7759 1001,2,7760, 1002,1,6924,7589 1002,3,7590,7799 1002,1,7800...

I have some problems to extract some data from a access database. The problem is that the table hold the entire history of all employees, and I need to extract only the valid value on all employees. Ex: Employee1, value1, FromDate: 16.12.2008 Employee1, value2, FromDate: 01.01.2009...