Query Criteria for Yes/No Box

[sparklegrrl]

We have several services per job. Such as

Inspection
Strip
Lining
SiphonPipe
Nuts & Bolt's
etc

I have a table and a query set up so that it pulls all the services performed up per job so that we can enter the invoice totals & print the necessary forms, however..we do not always bill for them at once so I created a print field and made it a yes/no box so it will only print the records selected.

How do I set the query so that it pulls all records from a job that have the print option selected?

I tried "is not null" but it isn't working. I need it to pull all the records where the yes/no box is checked.

THANKS!

 

[AncientOne]

WHERE MyCheckBox=True

should return the fields you need

 

[sparklegrrl]

THANKS!