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 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 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 03:39 PM
by Allen Browne Go to last post
1 191
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 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 215
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 02:12 AM
by MGFoster Go to last post
1 88
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,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 06:23 PM
by Steve Schapel Go to last post
1 85
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 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 01:52 PM
by Melinda Go to last post
7 88
Yes or No by Robert Smith[_2_]
I have a field that I want to query. The input is Yes or No. I'm trying to find an Iif statement that will do it.
February 17th, 2009 07:09 AM
by Allen Browne Go to last post
2 52
Yes No Combo Boxes Queries Filtering as 0 and 1 Instead....work ar by Richard Horne
Hi guys, I have a form with 5 combo boxes, the results of which are passed to a query to display a list of orders. One of the combo boxes is called...
May 19th, 2005 02:43 PM
by Nikos Yannacopoulos Go to last post
3 99
YES /NO Query by Rpettis31
I have a query that I want to list of all records that do not have a yes it is the yes/no data type and I am not familiar how you query from this data type?
July 1st, 2009 10:44 PM
by Clifford Bass[_2_] Go to last post
1 121
Yes / Yes + N Responses for percentage by Sue
I cannot find my post from yesterday. We have approximately 1200 employees that we are entering data in a table for their evaluations. We are entering the...
April 2nd, 2010 12:39 AM
by Duane Hookom[_4_] Go to last post
4 173
Yes / No query problem by Serendipity
* I have a qry that uses the information from 2 other queries with 2 calculated fields. * The "base" queries are pulling thousands of records to just...
October 16th, 2009 04:12 PM
by Serendipity Go to last post
4 144
Yes - No - N/A questions by DanG
I have a database set up to do quality reviews on files There are a number of questions with Yes, No, N/A as the possible outcome to each question. Each...
March 13th, 2008 02:30 PM
by DanG Go to last post
8 120
Years of Employment by Forsi
Hello I am trying to calculate the years a person is employed by the Company, taking into account the separation date, current date and hire date. For a...
June 2nd, 2008 02:52 PM
by Roger Carlson Go to last post
2 108
Years employed by Daryl
How do I calculate years employed for the...
February 11th, 2006 09:01 PM
by MGFoster Go to last post
9 139
YearMonth as column Headings by Terry
How can I produce column headings consisting of YearMonth for all of 2004? Starting at 200401 to 200412, or some other combination. I have data that will...
October 11th, 2004 09:59 AM
by Terry Go to last post
6 464
yearly blocker divided by weeks by gail
i'm looking for a one year planner, divided by weeks horizontally, with vertical data input.
February 10th, 2005 06:48 AM
by Duane Hookom Go to last post
1 156
YearFrac by Grace
Excel has a function named YearFrac() which allows you to specify where a year calculation uses 365 or 360 days. I would like to use this in Access, however,...
June 1st, 2004 06:59 PM
by [MVP] S.Clark Go to last post
1 644
Post New Thread


Display Options
Showing threads 121 to 140 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 10:05 AM.


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