Solved

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

Posted on 1998-07-30
1
1,008 Views
Last Modified: 2008-02-01
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
0
Comment
Question by:skundu
1 Comment
 
LVL 1

Accepted Solution

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

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

770 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