Re: is there a "does not include" query in Access
- From: "Van T. Dinh" <VanThien.Dinh@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 8 Jul 2005 01:13:41 +1000
You can use the (Not) In operator or the (Not) EXISTS Clause.
Alternatively, you can simple use a Left Outer Join like:
****Untested****
SELECT C.ClientID, ....
FROM tblClient AS C LEFT JOIN
(
SELECT DISTINCT Sub.frg_ClientID
FROM tblWorkIn
WHERE {Your Date Criteria}
) AS W
ON C.ClientID = W.frg_ClientID
WHERE W.frg_ClientID Is Null
****
Check the JET Reference on the In operator and the EXISTS cluase also.
--
HTH
Van T. Dinh
MVP (Access)
"cherylw" <cherylw@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:88BBFB7C-B66D-4BF4-82A0-7B248B6EA690@xxxxxxxxxxxxxxxx
> I am using Access 2000 and have a database with a Clients table (client #
is
> primary key, then includes name, address, phone...) and a Work In table
> (keeps track of when we receive each months work for each client). I need
to
> create a report that shows me which clients we have not received work for.
> Is there someway I can setup a query to find all clients that do not
include
> Work In for a specified month??
>
> Any help is appreciated.
>
> Thank you!!
>
> Cheryl W.
.
- Follow-Ups:
- Re: is there a "does not include" query in Access
- From: cherylw
- Re: is there a "does not include" query in Access
- References:
- is there a "does not include" query in Access
- From: cherylw
- is there a "does not include" query in Access
- Prev by Date: Re: append mult. tables into one
- Next by Date: Case Conversion
- Previous by thread: RE: is there a "does not include" query in Access
- Next by thread: Re: is there a "does not include" query in Access
- Index(es):
Relevant Pages
|
