joined tables in query, will not filter "no" properly

[Patty]

I created 2 tables and created a relationship using ID#, 1 to many. I used
both tables in a query. I can filter in the y/n box for yes, but not for no.
I can also filter y/n in the other columns as long as the first y/n column
has been marked yes. When I filter no, it brings up only those marked yes in
the first column. I can filter using "is null" in the design view.
Any suggestions?

Using Access 2007.
Thanks!!

Response from Steve C:

Select *
From [YourTableName]
Where Not [YourFieldName]

Should return all of the 'No' values.

Post your SQL in the Queries forum for mo'betta service.

My response to Steve:

Thanks Steve!!

I would like to know why the filter will not work. It works for yes, but
not no. Any thoughts?

 

[John W. Vinson]

I would like to know why the filter will not work. It works for yes, but
not no. Any thoughts?

NULL is not equal to No (or to anything else, for that matter). Might the
field be NULL, either because it's not actually a Yes/No table field in an
Access/JET database, or because of an outer join?