How to assign criteria for Yes/No?

[AccessThis]

Hi, I'm just building a simple accounting database and I have a yes/no checkmark field on my main table for account payable and account receivable i.e. AP and AR.



So I wanted to set up a query that only displays the records that have the AR checked. I looked through the forums and the book I am using, but I'm not really sure how to go about this.

I tried typing 'Is Not Null' in the criteria field without the ' ' and it did nothing. I also tried setting '=yes' but that also did not give me the desired effect.

I also wanted to do something similar with the other 2 cases i.e. if only AP is checked or if both AP and AR are checked, but I'm sure if I can figure out one, then I can solve the rest. Thanks a lot!

[AccessThis]

Nevermind, I just figured it out.

Just need to type a simple 'Yes' into the criteria without the ' ' and it will list all of the records where the checkmark has been filled out lol.