[AccessD] Query Help Needed

[John Bodin]

Hi Bill,

I tried this and although it fires off and returns records, it seems to exclude entire sequences of calls altogether.  I didn't dig too deeply into this as Don's suggestion seems to have worked.  Thanks for the reply and code.

John

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson
Sent: Sunday, March 15, 2015 7:29 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Query Help Needed

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)
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com