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 or no fields by Melinda
I have 3 yes or no fields, the first field is always a yes/Injury field and the 2nd/Lost Time and 3rd field/Medical can be yes or no depending on what action...
December 26th, 2006 12:52 PM
by Melinda Go to last post
7 88
Yes responses divided by yes + No responses for percentage by Sue
We have our data in a table for our evaluation of employees. What we need is group or total the number of Yes and No responses to equal the perscentage of...
(Multi-page thread 1 2)
April 2nd, 2010 12:46 AM
by Duane Hookom[_4_] Go to last post
14 373
Yes,Yes,Yes,Yes,Yes,Yes! in a query by paul.hoyle
I have a query that returns a number of fields - 6 of these fields could display the word "Yes" - how do I only show records that have 1 or more of these...
January 23rd, 2005 05:23 PM
by Steve Schapel Go to last post
1 85
Yes/No by ghostman via AccessMonster.com
I have this SQL that display training NO SHOWs. SELECT .TraineeID, Count(.NoShow) AS CountOfNoShow, .TSID, .ModuleName, .SessionDate FROM INNER JOIN ON...
September 1st, 2009 03:02 AM
by AccessVandal via AccessMonster.com Go to last post
5 217
Yes/No by taft71
I have set up several YES/NO fields and when they are checked off I would like to add them up. How is this done?
March 13th, 2005 01:12 AM
by MGFoster Go to last post
1 91
Yes/No by Sylvia
Ciao everybody I have a table (TBLCONTACT) with the following structu IDContact Client Product Date Time Comment YES/NO Counter Number...
August 1st, 2006 05:08 PM
by Jeff Boyce Go to last post
3 107
Yes/No as Criteria by AccessIM
I don't know if this is possible but here it goes... I have a form based on a table that contains yes/no fields labeled "Y", "N/I" and "N". A comment is...
April 6th, 2007 09:58 PM
by KARL DEWEY Go to last post
9 133
yes/no box by JKE
I have a table that holds actions pending from visits to branches. This table has a "completed" field which is a yes/no (check) box. I have a query which...
January 11th, 2007 02:39 PM
by Allen Browne Go to last post
1 191
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 05:45 PM
by Rick B Go to last post
4 92
Yes/No Data Type by FL
I have a field with a Yes/No data type that uses a field with a check box on my form. How do I designing a query to show all records with check mark or all...
June 22nd, 2007 01:02 AM
by Rick Brandt Go to last post
2 66
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 110
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 81
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 04:26 PM
by Marshall Barton Go to last post
1 91
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 107
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 01:41 PM
by Song Su Go to last post
4 73
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 192
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 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 01:45 PM
by Matt_Fairfield Go to last post
3 151
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
Post New Thread


Display Options
Showing threads 43161 to 43180 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 05:18 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.