|
|
Yes/No Queries by
Don Hicks
Hello,
I have an Access '97 database with a table containing a Yes/No checkbox
field.
When I query the records in the table with no "Yes/No" criteria...
|
June 9th, 2004 01:11 AM
by rey
|
2 |
216 |
|
|
Yes/No parameter for Yes or No or Both by
Owl
RonaldoOneNil gave me the very useful info of:
=IIF(="Yes",True,False)
for a parameter query criterion (for a check box in a form).
I would like to know...
|
February 26th, 2010 02:19 PM
by Owl
|
7 |
258 |
|
|
Yes/No parameter for selecting either by
Owl
I would like to know if it is possible in a query to have a parameter that
will allow the user to select either Yes or No, and if so please supply the...
|
November 19th, 2009 08:04 PM
by Owl
|
3 |
182 |
|
|
yes/no parameter by
Rocky
Simple question--how to make a paramenter in a query answer to a yes no
question?
|
September 12th, 2007 11:14 PM
by Klatuu
|
1 |
46 |
|
|
Yes/No or None by
Stephanie
Hi. I have a yes/no field for Coordinator. Each program has one
coordinator. I'm trying to figure out a query to find programs that have no
coordinator, but...
( 1 2)
|
|
12 |
255 |
|
|
yes/no or both Error 3071 by
javablood
I was following a thread on 11.19.09 by Owl and responded by Karl Dewey and
John Spencer and thought I had my answer but do not. I have a form in which
I...
|
|
2 |
185 |
|
|
YES/NO not working by
Dan @BCBS
I have a somewhat long Query that pulls from two tables.
When I add WHERE (((tblTrackingData.EXTENSION)=True)......
It does not give me only the True...
|
|
5 |
88 |
|
|
yes/no in UNION by
fl0pp3r
typical yes/no......turns to .....0/-1.....but this is in a Union....i can't
find a way to edit the format properties in the UNION....any ideas....and if
the...
|
|
1 |
56 |
|
|
yes/no in query by
C. Claes
Hi,
I have three tables: tbl_cust with customer data (client_ID, number, name,
adress, ...), tbl_priceincrease with increase_ID, date of price...
|
|
1 |
75 |
|
|
Yes/No from TextBox in query by
Igor G.
1. How to use values from !, in query?
Field in query is datatype Yes/NO.
When I put in query criteria values Yes/No, working OK.
But, when I call this...
|
|
2 |
83 |
|
|
Yes/No Format by
enrico1982
I have set up a union query that displays a yes/no field. On the original
table the results show as a yes or a no, but in the query they show as a -1
or a 0....
|
|
3 |
149 |
|
|
Yes/No fields question by
smk
I have about 20 fields of Yes/No data type. I would like to do a parameter
query where I type in the name of a field, and it will display all the "Yes"
of...
( 1 2)
|
|
11 |
143 |
|
|
Yes/No field showing as 0 -1 by
Penny Miller
I have a table that has a yes/no field in it called "completed", when I
create a query based off of this table this field shows as a 0 or a -1. How
do I...
( 1 2)
|
August 22nd, 2007 06:58 PM
by PennyM
|
12 |
160 |
|
|
yes/no field in query by
Song Su
Access 2003
I want to print label based on select query. The query pull out, for
example, 10 records. I want to use a form for user to check which of these...
|
February 6th, 2008 02:41 PM
by Song Su
|
4 |
73 |
|
|
Yes/No Field in query by
Claire
I feel really dumb that I can't get this to work, but here goes!
A dialog box filters a report by way of a query. The underlying table has a
yes/no field...
|
June 7th, 2005 09:42 PM
by Claire
|
5 |
105 |
|
|
Yes/No field display options? by
PatrickM
Can a Yes/No field display data in any format other than check/no check? Can
it display Yes/No or -1/0?
Thanks,
Patrick
|
|
1 |
91 |
|
|
Yes/No Field by
Denver
i have this calculated field in my query, is there anyway i can sort and
display only those with YES value?how? anyone out there is kind to help me...
Red...
|
|
2 |
60 |
|
|
Yes/No Field by
Denver
can anyone help me how to count the number of YES from my Yes/No Field in my
parameter query, is this possible?
I have my SQL here where can I put my...
|
September 17th, 2008 05:41 AM
by Denver
|
2 |
80 |
|
|
Yes/No Data type field and queries by
stacymae
Hi,
I have a yes/no field in my query I qould like toenter a criteria that would
only display fileds that are "No" or unchecked. Do you know what I would...
|
|
3 |
108 |
|
|
yes/no data type by
dlb1228
i have 2 queries and they both have yes/no fields in them. when i go to
datasheet view i can see the check mark in the field, but when i use a union
query to...
|
February 8th, 2006 06:45 PM
by Rick B
|
4 |
92 |