Unique Last updated records

Dear Frnds,

i have two tables one is on with unique records of employee (Emp id is Unique) and the second table is employee attendance (columns employee code, Attendance, Date) in that employee code is multiple in different dates

i need the employee latest attendance in first table.

thanks

Originally Posted by dflak

This article should help you: http://www.contextures.com/excelminm...ion.html#maxif

To understand why it works read this: http://www.utteraccess.com/wiki/Array_Formulas.

Dear

Thanks for your suggestion, my data is not in excel it's in access please guide how can get the Same in access,

Regards
Liju