A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
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 Go to last post
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 Go to last post
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 Go to last post
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 Go to last post
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...
(Multi-page thread 1 2)
August 19th, 2005 06:59 PM
by Stephanie Go to last post
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...
December 16th, 2009 07:48 PM
by javablood Go to last post
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...
January 13th, 2006 09:15 PM
by John Spencer Go to last post
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...
December 13th, 2006 04:51 AM
by Allen Browne Go to last post
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...
July 4th, 2005 04:54 PM
by Michel Walsh Go to last post
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...
July 12th, 2007 04:12 PM
by KARL DEWEY Go to last post
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....
January 7th, 2005 02:45 PM
by Matt_Fairfield Go to last post
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...
(Multi-page thread 1 2)
October 4th, 2006 01:45 AM
by Duane Hookom Go to last post
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...
(Multi-page thread 1 2)
August 22nd, 2007 06:58 PM
by PennyM Go to last post
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 Go to last post
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 Go to last post
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
March 19th, 2008 05:26 PM
by Marshall Barton Go to last post
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...
September 18th, 2008 07:26 PM
by Access101 Go to last post
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 Go to last post
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...
May 14th, 2005 10:10 AM
by Van T. Dinh Go to last post
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 Go to last post
4 92
Post New Thread


Display Options
Showing threads 101 to 120 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.