Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 1998-07-30
1
Medium Priority
?
1,021 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 150 total points
ID: 1957673
If you are using quotes, take them out. Yes, True, and -1 should all work.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

824 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