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

  • Thread starter Thread starter Patty
  • Start date Start date
P

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:

S.Clark said:
Select *
From [YourTableName]
Where Not [YourFieldName]

Should return all of the 'No' values.

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

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?
 
I would like to know why the filter will not work. It works for yes, but
not no. Any thoughts?
Click to expand...

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?
 
Back
Top