Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Location
    Minneapolis MN
    Posts
    2

    How to query boolean values from table


    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!!

  2. #2
    Join Date
    Jun 2005
    Location
    Northampton, England
    Posts
    14
    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.

  3. #3
    Join Date
    Nov 2006
    Location
    Minneapolis MN
    Posts
    2

    Boolean Query

    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Table values in forms
    By xzxz in forum Access
    Replies: 3
    Last Post: 10-28-2008, 08:29 AM
  2. Replies: 0
    Last Post: 10-23-2008, 12:08 AM
  3. Null Values not showing up in a Query
    By Valli in forum Queries
    Replies: 0
    Last Post: 01-04-2006, 03:53 PM
  4. Using same query with different table
    By fashoda in forum Queries
    Replies: 1
    Last Post: 12-14-2005, 12:05 AM
  5. Use same query with different table
    By fashoda in forum Access
    Replies: 1
    Last Post: 12-09-2005, 08:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums