Hi all,
Sorry to hassle you with this query, I'm sure the answer is a simple
one, but it remains elusive - to me anyway.
What I am trying to do is get a query to work. I have a table of people
(with ID's) and a table of languages (with People IDs and Language IDs).
Now one person may speak many languages. I have put in the relationship.
What I want is to be able to say pull out all the people wjo speak these
3 languages.
The query I manage to make is this
SELECT DISTINCT People.ID_Person
FROM People INNER JOIN People_LanguageSkills ON People.ID_Person =
People_LanguageSkills.ID_Person
WHERE (((People_LanguageSkills.ID_Language)=[Forms]![Form1]![Combo22]));
The moment I add
AND (((People_LanguageSkills.ID_Language)=[Forms]![Form1]![Combo32]))
It stops working. It now says that no-one speaks English (ID 1) and
French (ID 3). I have checked to make sure that there are people in the
People_Languageskills table who have both languages:)
I have tried to select from only the People_Languageskills table and
from the joined tables as above.
What am I doing wrong????
Thanks in advance
Jenni
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!