Yes/No Checkbox (Query) ....

[Lance H]

In the design view of a query, I am unable to establish what 'criteria' is used to indicate who has checked 'yes'. The 'like' criteria doesn't work (Like "*/true/*"). I am a basic Access user fumbling my way through putting together a database for my car club. Nothing is meant to be easy!! Thank you.

[davegri]

= True

use = instead of Like and drop the quotes

[June7]

You want to filter data on yes/no field and retrieve only those that are yes (true)?

Just type True (or -1) in the Criteria box. Access won't even retain = sign in Design view - it will show in SQL view.

[Welshgasman]

O/P posted back in wrong thread.

https://www.accessforums.net/showthread.php?t=36062