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

Posted on 1998-07-30
Medium Priority
Last Modified: 2008-02-01
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.
Question by:skundu
1 Comment

Accepted Solution

awd earned 150 total points
ID: 1957673
If you are using quotes, take them out. Yes, True, and -1 should all work.

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question