Access query when field's data-type is "Yes/No".

Hi,
I have a table whose fields are named as "A", "B" and "C".
The datatype of Field "C" is "Yes/No". So you need to "mark"
the records for the "C" field. Now I need to write a query
which will retrieve all the fields where content of "C" is
"marked"(ticked). How do you write the query in the design view. What is the criteria field for "C"? I tried with "Yes"/"1"..but it does not work. Seek your help.
Thanks,
Sunanda
skunduAsked:
Who is Participating?
 
awdConnect With a Mentor Commented:
If you are using quotes, take them out. Yes, True, and -1 should all work.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.