Yes/No Data Type Mismatch

[Pestomania]

Hi. I have a table with three fields: ID, Full Name, yes/no

I then have two queries:

One query is using this table to see "yes" and the other is looking for "no". But whenever I attempt to run the queries, it tells me there is a data type mismatch.

I am unsure what I am doing wrong!

 

[James006]

Hi,

Could you be a bit more explicit ...

What is your actual ' query ' ... ?

 

[welshgasman]

Use True or False, not Yes and No

 

[Pestomania]

Hi everyone, thank you for replying. I figured it out a few minutes ago. In the criteria I was putting "yes" and "no" and wasn't aware that it should not have quotation.

Sorry for wasting time.