how to set criteria for a checkbox 1

[timrob]

I have a report that should only return rows that have a checkbox selected. The report is referencing a table. In the table, one of the columns is a checkbox.

In the query for the report, how do I set the criteria to only filter to the checked items? I've tried 'Not Null', 'Is Not Null' or 'Like "*"' and they don't work. Every recordset appears on the report.

'Is Not Null' or 'Like "*"' works on text columns, but I can't get them to work for the checkbox columns. In the table, I can right click and filter by selection on the checkbox column.

Any ideas? I've been working on this report on and off for a while now and finally have it down to this one last item.

 

[Remou]

Try True, Yes or -1

 

[timrob]

Thanks, you made my day. You wouldn't believe how long it took me to get to this but.