Yes/No Data Type Mismatch

Pestomania

Board Regular
Joined
May 30, 2018
Messages
108
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

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hi,

Could you be a bit more explicit ...

What is your actual ' query ' ... ?
 

Pestomania

Board Regular
Joined
May 30, 2018
Messages
108
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.
 

Forum statistics

Threads
1,085,723
Messages
5,385,468
Members
401,956
Latest member
MadameHugo

Some videos you may like

This Week's Hot Topics

Top