请问一个查询的问题

真主

真主

SELECT *
FROM C002 AS a
WHERE (((a.加入日期)=(select max(加入日期) from C002 where 员工统编ID=a.员工统编ID)));

已解决，谢了

一点通

SELECT DISTINCT 表1.姓名, DMax("[日期]","表1","[姓名]='" & [姓名] & "'") AS 最后日期, DLookUp("[职务]","表1","[日期]=#" & [最后日期] & "#") AS 最后职务
FROM 表1
GROUP BY 表1.姓名, DMax("[日期]","表1","[姓名]='" & [姓名] & "'");