S
SweetJoy
To summarize, I have an Employee Query (all queries pulled directly from
tables, where applicable), a Skills Query, and an Employee-Skills Query, that
constitutes all of the skills that each employee has (ie. Employee 1 - Skill
3, Employee 1 - Skill 7, Employee 2 - Skill 1, Employee 2 - Skill 3, Employee
2 - Skill 7, etc). When querying the database I want to be able to retrieve
only Employees that have ALL of whatever Skills are entered by the searcher.
The best I can do so far is have it return all Employees that have, for
instance, either Skill 3 OR Skill 7, not only Employees that have both Skill
3 AND Skill 7.
Here is my code so far (simplified, but still functional):
SELECT [Employee Query].LastName, [Employee Query].FirstName, [Skills
Query].[Technical Skill]
FROM [Employee Query], [Employee-Skills], [Skills Query]
WHERE ((([Skills Query].[Technical Skill])=[Enter First Skill:] Or ([Skills
Query].[Technical Skill])=[Enter Second Skill:]) **using 'AND' instead of
'Or' here, which seemed intuitive to me, doesn't work**
AND (([Employee Query].EmployeeID)=([Employee-Skills].[EmployeeID])));
AND ((Employee-Skills.SkillID)=([Skills Query].[SkillID])) **joins all my
tables together**
I looked through some old responses and found mention of 'InStr' but can't
quite figure out how to use it appropriately.
Can someone please help?
tables, where applicable), a Skills Query, and an Employee-Skills Query, that
constitutes all of the skills that each employee has (ie. Employee 1 - Skill
3, Employee 1 - Skill 7, Employee 2 - Skill 1, Employee 2 - Skill 3, Employee
2 - Skill 7, etc). When querying the database I want to be able to retrieve
only Employees that have ALL of whatever Skills are entered by the searcher.
The best I can do so far is have it return all Employees that have, for
instance, either Skill 3 OR Skill 7, not only Employees that have both Skill
3 AND Skill 7.
Here is my code so far (simplified, but still functional):
SELECT [Employee Query].LastName, [Employee Query].FirstName, [Skills
Query].[Technical Skill]
FROM [Employee Query], [Employee-Skills], [Skills Query]
WHERE ((([Skills Query].[Technical Skill])=[Enter First Skill:] Or ([Skills
Query].[Technical Skill])=[Enter Second Skill:]) **using 'AND' instead of
'Or' here, which seemed intuitive to me, doesn't work**
AND (([Employee Query].EmployeeID)=([Employee-Skills].[EmployeeID])));
AND ((Employee-Skills.SkillID)=([Skills Query].[SkillID])) **joins all my
tables together**
I looked through some old responses and found mention of 'InStr' but can't
quite figure out how to use it appropriately.
Can someone please help?