[AccessD] Query Help Needed

[Bill Benson]

I am wondering if something like this might work?

Select CallNo, AssignDate,TechID
>From tblCallsTechs as A
Where not exists
(Select AssignDate,TechID from
tblCallsTechs as B where A.CallNo = B.CallNo and A.AssignDate > B.CallDate)