How to retrieve data based on check boxes

[Coach Ty]

Hello,

I'm new to access and I was wondering if anyone can please tell me how to structure a query, so that it returns information based on the true/false designations of multiple check boxes?

I have an employee data base that contains various categories of information. What I need to do, is design a query that will return only the employee's information, that meet specific criteria, based on the true/false values of muliple check boxes.

In other words, if I have four text boxes, "A", "B", "C" and "D". and I want to return only the employees, who have a true value in "A" and "B" and a false value in "B" and "C", how can I structure a query to perform this action? Is it possible to do using only one query, or do I have to use multiple queries, to retrieve the desired information?

Any help you can give me will be greatly appreciated.

Thank you!

 

[MarkK]

You can use one query. You write a WHERE clause that encapsulates the logic you'd use to select a record. When the expression in the WHERE clause evaluates to True for a particular record, that record is included in the subset of records returned by the query.
The logic you've described would produce a where clause that looks like...

WHERE A And B And Not C And Not D

Cheers,