yes/no queries

[sherri]

I have a form that has six different yes/no boxes for different divisions of
the company and whether jobs are completed or not. I can't seem to get a
query to work where the user would enter the customer name and the results
would return all the incomplete jobs in any of the three divisions. I can
get it to return the results if the customer only uses one division but i
can't get the multiple divisions down. Any help would be greatly appreciated.

thanks

 

[Tom Ellison]

Dear Shem:

You do not describe how your data is organized. Assuming it has been
correctly designed, you would have one column in which the boolean value
(yes/no) is stored in 6 different rows.

In this case, I would recommend you simply COUNT() the rows for the
cross-product of Job X Division in which the Completed value is true. When
this value is 6 then the job is completely completed.

A more general solution would be to have both a count of the Yes values and
also a count of the number of applicable divisions.

You do not explain how a "Customer" is involved. I would have expected that
it would be possible for a single customer to have more than one Job. Are
the results, then, perhaps for all the Jobs related to the selected
Customer?

In order to receive specific assistance, you must give sufficient sample
data with table and column names. Please also indicate the desired results.
Perhaps then you will receive the exact help you desire.

Tom Ellison