Very simple query statement

[sysr]

I don't use Access much and need a little help with a query.

I have a Clients query with a list of IDs (identifying the client) and a Report query with a list of IDs (same ID# as client ID, and there may be some IDs that are listed several times).

I want to see which Clients IDs are not in the Report IDs.

Here is my failure:
SELECT Clients.ID WHERE Clients.ID NOT IN Report.ID;

Thanks for any help.

 

[PWise]

select Clients.ID
from Clients
left join Report
on Clients.ID =Report .ID
where Report .ID is null

 

[PHV]

And to follow your oiginal idea:

SELECT Clients.ID
FROM Clients
WHERE Clients.ID NOT IN (SELECT Report.ID FROM Report)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[sysr]

Thanks you so much, it works great!!!