Query

Topic

New Reply

I am doing a query on a table that has a yes/no check box. I want only the records that have not been checked. I have used “Is Null” in the criteria but this does not work. Can someone help me out. Thanks.

Reply | Quote

Replies

DID YOU SET THE CRITERIA AS “IS NULL” OR Is Null. if you set the critera as “IS NULL” You will be searching for the actual words IS NULL instead of null
jerryc

Reply | Quote

Hi,
Try setting the criteria to No or to False or to 0 (zero not O). For a yes/no field checked is yes/true/-1, unchecked is false/no/0.
Hope that helps.

Reply | Quote