SQL for yes/no type data
Posted on 2000-02-20
I have an access table with yes/no data type. Each of the fields in the table has a box, which can be checked (presumably meaning "yes") or unchecked (i. e. empty presumably meaning "no"). An attempt to query this data table produced the following error. I guess there is another way to form queries with this data type. Please help.
SELECT * FROM tblLinkNames WHERE P6 = 'Yes'
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
The request properties can not be supported by this ODBC Driver.
/infopages/search_results.asp, line 44