Loading data using efffective date

[#1]

Good day

I need assistance, I am trying to load data that has distinct values but I want to only load the most recent data of the employee using the last effective date.

[MK_QSL]

Temp:

Load

  EmployeeID,

  Date([Effective Date]) as [Effective Date]

Inline

[

  EmployeeID, Effective Date

  A, 01/01/2014

  B, 01/02/2014

  A, 15/05/2014

  B, 18/04/2014

  C, 10/02/2014

  A, 20/02/2014

];

Final:

Load

  EmployeeID,

  Date(Max([Effective Date])) as MaxDate

Resident Temp

Group By EmployeeID;

Drop Table Temp;