Filter query to False on a Boolean (YN) Field

[tgall]

Short trip: How do I build a query that filters records to only those where Boolean = False?



Scenic view: The Access database is linked to tables on a SQL Server. One of those tables, dbo_tblRequestAnswer has a Boolean field of Yes/No, which Access assigns data type Yes/No.
The table has 3.7 million records. I built a query to filter dbo_tblRequestAnswer to:
1) Those whose RequestID = [Forms]![frm00Menu].txtRequestID. Works.
2) Those whose originalAnswerIndicator = No (False). Doesn't work. No records appear.

The resulting record set is then saved in a maketable, entitled mktblqry05.
When I don't insert any "where" criteria, the originalAnswerIndicator field is filled with -1 or 0.

The following is the query:
SELECT DISTINCT dbo_tblRequestAnswer.RequestID, dbo_tblRequestAnswer.originalQuestionID, dbo_tblRequestAnswer.originalAnswerIndicator, dbo_tblRequestAnswer.originalAnswerDescription INTO mktblqry05
FROM dbo_tblRequestAnswer
WHERE (((dbo_tblRequestAnswer.RequestID)=[Forms]![frm00Menu]![txtRequestID]) AND ((dbo_tblRequestAnswer.originalAnswerIndicator)=Fa lse));

How can I make the "False" segment work?

[JoeM]

AND ((dbo_tblRequestAnswer.originalAnswerIndicator)=False));

should work, but so should:

AND ((dbo_tblRequestAnswer.originalAnswerIndicator)=0));

Try the second and see if it works.

[tgall]

Joel, thank you for responding to my question. I changed False to 0 in the SQL rather than the query wizard. No records appeared.
I also tried True and -1. No records.

I also created a maketable of just the record set filtered from [Forms]![frm00Menu].txtRequestID. The maketable assigned originalAnswerIndicator data type Yes/No.
The field is filled with 0 and -1. I then created a query of the maketable and tried to filter to False. No records.

I opened the maketable in Datasheet View and right-click-filtered on 0. The table filtered to just the 0 records.

I don't understand why the query SQL doesn't filter the records.

[JoeM]

A few things to try:
- Try making it just a Select query at first and see if it returns any records
- Try removing the other criteria so you just have this boolean field criteria and see if that returns any record