Query/check box issue

[Guest]

Hello,

I have a problem with a query I am making. I have a checkbox on a table to
indicate yes/no to something. When I query using that checkbox, 4 of my
records for which the checkbox is not checked (No or False) don't appear.
When I export it to Excel, which I did to test, all seems fine, there is a
false value for checkboxes that are not clicked.

Any ideas? I am a fairly new Access user.

Thanks! Laurie

 

[Guest]

Laurie:

What is the data type of the field? If its Boolean (Yes/No) then it can
only have a value of True or False, but if its an Integer Number it can also
be Null. Null is not a value, but the absence of a value and all equality
comparisons involving Null evaluate to Null, so if you are testing for the
value being False it would not pick up any Nulls.

If the field is of Boolean data type then I'd suspect something else is
preventing the rows being returned, e.g. if the query INNER JOINs the table
to another table and there are no rows in the other table to match the four
rows in question, then the query would not return those rows. In cases like
that you'd use a OUTER JOIN (LEFT or RIGHT depending on the query) to return
all row from one regardless of matches in the other.

There could be other reasons the query is not returning the rows of course,
if it has criteria on other fields for instance where an AND operation has
been used instead of an OR operation.

Ken Sheridan
Stafford, England