Hello Everyone, I am kind of new to Access and SQL in General and have a table of employee skills and have them as boolean values. I want to query the table and find out which columns have been checked also how would I have a form ask to this query so someone could look for certain skills in a emloyee and have the query return employees who have some or all of the skills.
Thanks for the help!!

Create a query that uses the boolean value True as the criteria if you only want those that have a skill. In the saame query you could have a parameter that asks for the skill. Here is some SQL that will do just that.

SELECT tblEmployeeSkill.SkillID, tblEmployeeSkill.Skill, tblEmployeeSkill.SkillYesNo, tblEmployeeSkill.Employee
FROM tblEmployeeSkill
WHERE (((tblEmployeeSkill.Skill)=[Enter skill]) AND ((tblEmployeeSkill.SkillYesNo)=True));

Change the field and tables names as appropriate.

Thank you very much.

I need a little more help.

I have the 20 or so skills in a form with checkboxes next to them and I want the employer to be able to query using the same kind of form to do their query by checking boxes and entering a jobsite # to return the employees who have some or all the skills. I have my tables set up with the employees, the skills and the jobsites related by EmpID and Jobsite. I understand how the query works that you sent but I am wondering how to do a query with a checkbox form to choose the skills needed or is it not possible.
Thanks for your help.