Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: NicuPetric
- Order by date
-
Looking for Sql code for my Querry!
Both solutions: LittleSmudge & r937 are fine, thanks boys. This was the solution I was thinking of but was not able to find the code.(my first access project). The ideea of using the count function to compare the number of required KHows is tricky. The structure I posted was a simplyfied one, in...- NicuPetric
- Post #9
- Forum: Microsoft: Access Queries and JET SQL
-
Looking for Sql code for my Querry!
Tables: (links between + +, # #, * * and - -). 1.tJobProfile JobProfileID + JobName Details 2.tLinkProfileKnow (Activity Matrix) JobProfileID + KnowHowID # 3.tKnowHow (List of possible Know Hows) KnowHowID # * Name Description 4.tLinkEmpKnow KnowHowID *...- NicuPetric
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Looking for Sql code for my Querry!
Tables: (links between + + # # and - -. 1.tJobProfile JobProfileID + JobName Details 2.tLinkProfileKnow (Activity Matrix) JobProfileID + KnowHowID # 3.tKnowHow (List of possible Know Hows) KnowHowID # * Name Description 4.tLinkEmpKnow KnowHowID * EmployeeID -...- NicuPetric
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Looking for Sql code for my Querry!
Ok! 1. I have 5 tables in this relationship 2. How can I code the fact that all the KnowHows a Job requires must be met by the employee that matches the criteria.- NicuPetric
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Looking for Sql code for my Querry!
I have 2 * "many to many" relations in my MS Access database. 1. Employee vs. KnowHow linked by linkEmpKnow 2. JobProfile vs. KnowHow linked by linkJobKnow I would like to filter employees by a certain JobProfile(the employee should have at least all the knowhows the Job requires). Thanks!!- NicuPetric
- Thread
- Replies: 8
- Forum: Microsoft: Access Queries and JET SQL
