Distinct query?

[Kivan]

Hi,

I have 3 tables. People, Projects and Metrics. Table metrics holds IDs from People and Projects.
I'm trying to make a query. In this query I would like to see all of the people who are not assigned to the particular project. For example, I have a project with ID number 3. I also have 4 people in database. Person with ID number 1 and number 4 is assigned to project with ID 3. Now I want my query to show all of the people who are not assigned to the project number 3. So it should show two people with ID 2 and 3, and for those records IDmetrics does not exist. I've attached a sample of this database.

Thanks for your time.

[recyan]

Check out if below gives some guidelines :

SELECT tblPeople.IDpeople, tblPeople.PP
FROM tblPeople 
WHERE 
IDpeople 
NOT IN 
(
SELECT tlbMetrics.IDPeople
FROM tlbMetrics
WHERE (((tlbMetrics.IDProjects)=3))
)

Thanks

[Kivan]

Yes it works! I only changed

WHERE (((tlbMetrics.IDProjects)=3))

Into this

WHERE (((tlbMetrics.IDProjects)=[TempVars]![test]))

To be able to set value as I want. Now I need to move it to real project which is a lot more copmlicated, but the idea is good. I will mark this tread as solved when it will be done. Thanks for your help .

Edit: Everything works great. Thanks again !

[recyan]

Glad you found it helpful.

Thanks