[AccessD] Query Help Needed

Bill Benson bensonforums at gmail.com
Sun Mar 15 22:38:13 CDT 2015


Yeah it was just a check.... I think something like it could work but
generally Exists and Not Exists run better with Pks.
On Mar 15, 2015 9:29 PM, "John Bodin" <jbodin at sbor.com> wrote:

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


More information about the AccessD mailing list