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?