Simple Query?

[RIck5150]

Hello. I am new at Access 2003 and I am trying to create a simple query as follows:

The query is connected to a form that has 3 checkboxes. The results of the query will help generate a report.

At worst, I would like the query to return ALL records where ANY of the checkboxes are empty.

At best, I would like to have 3 categories (one for each checkbox) and would like the query to show each record for each category where the specific checkbox is not checked.

If all 3 checkboxes are checked, the record will NOT appear on the report.

Any help is appreciated.

 

[Bilbo_Baggins_Esq]

Are the check boxes based off actual fields in an underlying table or are they unbound on the form?

If unbound, will the form be open or closed when the query needs to run?

 

[RIck5150]

Yes, the check boxes are based off actual fields in the underlying table.

 

[Bilbo_Baggins_Esq]

ok, kewl.

In the design grid, notice how there are several rows where criteria can be applied.

What you need to do is place all the fields to want to show into the deign grid, and include all three of your checkbox fields.

since your looking for any records in which any of the checkboxes is false (empty), you'll want to place a criteria for each checkbox field as FALSE, but do it one on each row of the criteria.

Here is an example of how you'd layout the criteria (I'll have to use a "code" tag so it sees my spaces):

Color  8inch   12inch   16 inch
Blue   false
Blue           false
Blue                     false

 

[RIck5150]

Excellent! Thank you!