帮忙看看这代码错哪了？

sxgaobo

  sqlstr = "Select * From 领单 Where 姓名='" & DLookup("[姓名]", "现操作员表") & "' and Max([领用时间])"

todaynew

sqlstr = "Select top 1 * From 领单 Where 姓名='" & DLookup("[姓名]", "现操作员表") & "'"  order by 领用时间 desc

cgsilicone

如果没有理解错,可以试试这个:
sqlstr = "SELECT * FROM 领单 WHERE (姓名 In (select 姓名 from 现操作员表))  AND (领用时间 In (select Max(领用时间) from 领单 group by 姓名))"

sxgaobo

{:soso_e183:}谢谢二位{:soso_e179:}{:soso_e100:}