General :: Counting Yes / No Boxes In A Row
May 14, 2013
So I'm fairly new to access as I've only spent one semester working with it. I have a project (work related, not school) that I can't seem to get a handle on.
I have a database with several yes/no fields (y/n)
name | y/n 1 | y/n 2 | y/n 3 | y/n 4 | etc
Is it possible to count how many occurrences of yes appear in each row in the table, and do that for every row? The object is to have a "grading system" if the person has like 4/5 then they are an A while another who has 2/5 is a D.
If this can be done then I can use this to come up with a way to deal with some of the other fields I want to tally and grade.
View Replies
ADVERTISEMENT
Jun 19, 2005
hi guys
i have 2 questions
1.
how can i count selected or not selected checkbox fields (yes/No) in a tex box ?!
( for example we have a 2 yes/no fields that are Male and another Female , and i want to make a form that shows number of males and number of females that selected in a text box )
2.
how can i make a search form that when i chose check boxes and then Search button it will show me the list of selected checkbox that selected in main form
( for example if we have 3 checkboxes 1.(low) 2.(mid) 3.(high) in main database and form , and if i want to make a search form that shows me list of enterees that is (Mid) )
thanks alot
View 8 Replies
View Related
Mar 20, 2007
I've asked this in a previous post but only got confused. Please forgive me, I'm a newbie at this. I have a table that I need to count a text field.
Table Name: ACE/ARB Table
Field Name: MR# (houses a 8 digit patient number)
Field Name: Failed Patient (houses a "TEXT" field with possible entries of "YES" "NO" or left blank.
Each MR# may have may different entries such as:
MR# 12345678 Failed Patient: YES
MR# 12345678 Failed Patient: NO
MR# 12345678 Failed Patient: NO
MR# 12345678 Failed Patient: (blank)
MR# 87654321 Failed Patient: NO
MR# 87654321 Failed Patient: YES
I need my report to count distinct MR#'s:
From the example above, I would need my report to show/count "2" medical records.
Any help on this would be GREATLY appreciated, I'm going crazy here. Also, if any suggestion has to do with SQL do I type what you would send me directly into the SQL statement from a query?
View 7 Replies
View Related
Apr 24, 2006
Hi guys, I'm new to Access and am in great need of some help.
I have a query that serves kind of as an attendance tracker where the students are listed down the left side with the weeks across the top. A check box is in each column that is checked to mark their attendance.
Now the problem: I need to figure out a way to sort by those who have been to 80% or more of the meetings. Preferably by it checking a box automatically in the "80% or more" column. Not sure if Access can do all this. Please help.
Thanks
View 4 Replies
View Related
Feb 18, 2014
I have set up a database to record several different sets of records for a volunteer group that I run. The types of records that I am keeping are hours on duty, uniform issued and attendance at training. The attendance form is a subform which contains a list of dates and the two fields of checkboxes showing if they attended or sent their aplogises.
What I am trying to do is to count the number of times that members attended training. I have set up a 'unbounded' text box in the footer and would just like to add a formula in to the command box of the box properties. Anything more i.e. coding then it goes over my head very quickly.
View 3 Replies
View Related
Jun 6, 2013
I've got a table with 23 columns. Column 1 is the ID row which has a unique client ID in it. Then we've got a column called 1st_Reason and one that goes with it called 1st_Transfer_Date. This pair repeats for 2 through 10. Each of the Reason columns can have a set value, for example "First Processor".
What I need to do is create a date with months on the Y axis and the 5 different reasons on the X axis. I need to count the number of "First Processor" across all 10 Reason columns for each month. I would need to repeat that for each other reason type, but if I can get one to work I can simply change the reason type.
Here's what I'm using to count May's total:
Code:
=Sum(IIf([Current_Reason]="First Processor" And [Current_Processor_Transfer] Between #4/30/2013#
And #6/1/2013#,1,IIf([1st_Reason]="First Processor" And [1st_Transfer_Date] Between #4/30/2013#
And #6/1/2013#,1,0)))+(IIf([2nd_Reason]="First Processor" And [2nd_Transfer_Date] Between #4/30/2013#
And #6/1/2013#,1,IIf([3rd_Reason]="First Processor" And [3rd_Transfer_Date] Between #4/30/2013#
[Code] .....
I get wildly inconsistent results. On one of the types, it's only counting where it's the 1st_Reason. Some of the others return the same value regardless of which month I have selected.
View 2 Replies
View Related
Jan 25, 2015
I have strange issue when creating auto populated text boxes which displays rows from combo boxes.
In one database auto populates works with simple text box Control Source edit "=[ComboName].[Column](NumberOfColumn)".
Somehow same method doesn't wotk in different database: here one time I have to insert VBA code at On change Event:
Me.TextBoxName = Me.ComboName.Column(NumberOfColumn)
And other time it wont work with On change but only with After Update Event (code is same).
Another thing this morning happens was that when I tried to add new record trough form where combo box and tex boxes are located, MS Office suddenly stopped working after selecting combo box selection (with message Microsoft Office has Stopped Working). It is 2013 version.
I got it work after deleting and re-inserting VBA code to autopopulate text box at After Update Event.
View 3 Replies
View Related
Mar 21, 2013
I have a table which has sentdate invoices and paiddat invoices. i want to be able to get a monthly count for the amount of invoices sent and paid to compare on a graph. e.g jan 2011 = 5 feb 2011 = 6 ect
View 1 Replies
View Related
Aug 21, 2014
I have a results database that collates information that is collected monthly over numerous locations. It's a temperature result. What I want to be able to do is count the excursions. So temperatures greater than 30 for instance is a fail....29 and below is a pass. I have 14 results per location. How I can summarize this?
View 7 Replies
View Related
Oct 16, 2013
I am looking to do a calculated field. Not sure what is the best way to do this, but I would like to have a dates in a table with all of our employees that has what date they started with the company. From that I want to know not how many days they have been with the company, but just the years.
So if I have been with the company 364 days, it should only show up as 0, and if I have been with the company for 365, it will read 1. I would like this to be in a query somehow. We use the number of years they have been with the company for their pay, and need it to be years, and not days.
View 9 Replies
View Related
Jun 18, 2012
I'm having a problem trying to have my query place the group record count on my form. The scenario is this: I have the query name (SPED Main Query Count) group the School Name field and then count the school name which in turn gives me a count of each school. but for some reason the field in the table name School Cnt will not build a relationship with the Countofschool Name in the query in my relationship.
View 13 Replies
View Related
Apr 25, 2013
counting in access on a make table query.I work for a recruitment company, and have a table for the vacancies we raise. I then have a table linking to this where you can record the candidates submitted for each role. The 'CVSubmitted' and '1stInterview' are a check box yes/no. I now want to run a query where I have a sum of the total number of CV's and 1st Interviews for each role.
View 1 Replies
View Related
Jan 26, 2007
I have a report due the first of each week in which I need the cases open and cases closed for the previous week, the week two weeks prior and the 2007 and 2006 year to date on two different types of cases. I have a case management table with a field for Type of Case, date assigned and date closed that I uses in my queries. Presently I have two query, one that generates only Type 1 cases from the Case Management Table and another for Type 2. I then use the Type 1 Query in another query that limits the results for Type 1 cases to those opened last week, one for those open two weeks ago, one for 2006 YTD and one for 2007 YTD. In these 4 queries I have one field [Type of Cases] and I have the query count. I then do this for Type 2 cases and then go through the whole process to do Closed Cases. All my queries have criteria to automatically filter the dates to the time periods mentioned above. I then have one report query that I put all the number in for my report. This query has 16 fields with the numbers for each period, last week open and closed, 2 weeks open and closed, etc. I then generated a report that takes these numbers from my report query and puts it in a report format automatically. As you can imagine this takes some time to go through each query to generate these numbers, so I was wondering how I may do this differently. Also, I have experienced a problem when a field produces no records I get a blank sceen with nothing under the Count of column and get the same thing for my report. How can I fix this.
View 1 Replies
View Related
Dec 26, 2012
I am new ussing access already with issues surprice no.I have four tables Section, Ducument, Description, Origin.I nees to Synchronize four Combo boxes, my first combo box code work fine
Private Sub cboSection_AfterUpdate()
Me.cboDocument.RowSource = "SELECT DocumentName FROM" & _
" [Document] WHERE SectionID = " & Me.cboSection & _
" ORDER BY DocumentName"
Me.cboDocument.Enabled = True
End Sub
When I select a category from my first combo box the secon combo box get populated with the correct Data.But when I select the second box the third combo does not get populated with any data here is my code for the second combo box.
Private Sub cboDocument_AfterUpdate()
Me.cboDescription.RowSource = "SELECT DescriptionName FROM" & _
" [Description] WHERE DocumentID = " & Me.cboDocument & _
" ORDER BY DescriptionName"
Me.cboDescription.Enabled = True
End Sub
View 8 Replies
View Related
Aug 12, 2013
What I am trying to do is, for example, I have 2 combo boxes, you can select a value in the first one and search and your results match the criteria, or you can select a value in the first AND second one and the records dispalyed will match the first AND second combo box criteria.
View 2 Replies
View Related
Jul 10, 2013
Working in MS Access 2007.
I am creating a small database for a budget and Im trying to create 3 cascading combo boxes on a form (areabox2 , devbox2, entitybox2) . I have it right now so that that
devbox2 is based on areabox2
and
entitybox2 is based on devbox2
BUT!!!!!!!
I want entitybox2 to be based on both areabox2 and devbox2
Parameters are :
Table = Budget Info
areabox2 data = [Budget Info].[Project Area]
devbox2 data = [Budget Info].Development
entitybox2 data = [Budget Info].Entity
This this the code im currently using :
Private Sub areabox2_AfterUpdate()
devbox2.RowSource = "Select DISTINCT [Budget Info].Development " & _
"FROM [Budget Info] " & _
"WHERE [Budget Info].[Project Area] = '" & areabox2.Value & "' " & _
"ORDER BY [Budget Info].[Development];"
Me.devbox2.Requery
[Code] .....
I am thinking that i have to add a second WHERE clause to the devbox2_AfterUpdate() but i dont know how?
View 7 Replies
View Related
Aug 5, 2015
I have a form with text boxes and after I click on the text box, the field gets grayed out. I can still read my text but I would rather it have it stay white.
MS Access 2010
View 3 Replies
View Related
Sep 19, 2013
I have designed a main form which have buttons for about 30 different companies name to open, each button opens an individual company form. Now the companies list is growing day by day so i want to create a combo box which select the company name and open the relevant company's form.
Do I need to create a table which lists all the companies and then add a combo box on a main screen which select the company name and open the form but i need a VBA code for that.
View 14 Replies
View Related
Jan 23, 2013
Basically, I have progress table with learners and each learner must undertake 4 tests. Once they have completed each test, in the original learner table, I want it to show that they have completed the task if all 4 boxes are checked by it triggering one final check box.
View 2 Replies
View Related
Sep 5, 2012
I wish to produce a delivery note which needs to print an empty box for manually ticking.
I need a box for each item quantity i.e 5 items on the job print 5 boxes. 20 items print 20 boxes.
I have been able to use very crude code if there is only a few items, using if qty =1 then / 1/ else if qty = 2 then / 1/ / 2 / etc etc ...
That works and prints the / 1 / 2 / which is ok but there must be a simpler way as it the job has more that it would be much better and far more useful for other reports to print a box or item.
View 7 Replies
View Related
Aug 19, 2015
I have several tables with the same Fields, I want to just tick one table and update the other tables that have the matching information as ticked.
View 14 Replies
View Related
Sep 3, 2012
I have created a multivalue field which allows me to select many names which form s a circulation list for a report. The multivalue drop down works ox in table view, however when I am in form view the dro down is missing the check boxes....
View 3 Replies
View Related
Jan 18, 2013
I'm trying to Identify a particular entry in my table for editing via combo boxes. The same serial number will come in multiple times but a different job number each time it comes in. To identify a record for editing I need the user to identify the serial number in combo1 and then the job # in combo2 (cascaded combo boxes).
The issue I'm running into is that combo1 has dozens of serial number duplicates (combo2 is acting as it should). When I change some settings around I'm able to get combo1 to eliminate duplicates but now combo2 only shows 1 job # when there should be dozens for that serial #. I need all like serial numbers to show their job # in combo2 and I have not had any luck surfing around the net/forums/experimenting.
I'm pretty sure I have to use a Junction Table but I haven't messed with that and I'm not 100% sure that's the best/only way to do it.
View 8 Replies
View Related
Sep 4, 2013
I am making a form at work for a coworker with cascading combo/list boxes where she can select a Customer, then Platform Description, then Period, then Year. I used VBA code for this and it's working perfectly - for single selection. I want to update this so she can select multiple Platform Descriptions and/or Periods and it will give all the applicable info.
I can use or a way to set up a query, etc. so that multi-select will work for me? Unfortunately, just changing the formatting to multiselect makes the listbox just blank white, so I'm assuming it's going to be more complicated.
(Here's the code I currently have for the cascading combo/list boxes, if you need it. SD0039DA_T is the table name where my listboxes are pulling info from.)
Code:
Option Compare Database
Private Sub Form_Load()
On Error Resume Next
CustomerCB.SetFocus
PlatformDescriptionL.Enabled = False
PeriodL.Enabled = False
YearCB.Enabled = False
End Sub
[code]...
View 3 Replies
View Related
Jun 29, 2014
I have a table with the following 5 fields. (Service Type), (Valve Name),(Size),(Rating),(Description).
I want to do two thing:
First: I want to select the required information from the first 4 fields using combo boxes and get the last field (description) based on the selected 4 fields. In other words, i want the record to be filtered using first 4 fields to give me the last field info.
Second: I want to store the filtered record (all 5 fields) in another table.
View 6 Replies
View Related
Jul 5, 2013
I'm jumping to the forms development and going to try what I need via queries and SQL. I'm trying to do a series of cascading combo boxes which have worked out fine, right till I hit the first junction table.
I will include the VBA code below as well as a screenshot but here's how it goes.
REGION cascades down to COUNTRY cascades down to PORT and then to CARRIER.
This is for a shipping program.
When it gets to PORT and are trying to cascade to the various CARRIER's thats where it hits a junction table of PORT_CARRIER.
Here is REGION to COUNTRY:
Me.cboCountry.RowSource = "SELECT COUNTRY.CNTRY_ID, COUNTRY.COUNTRY FROM COUNTRY " & _ " WHERE REG_ID = " & Nz(Me.cboRegion) & _
" ORDER BY COUNTRY"
Me.cboCountry = Null
COUNTRY to PORT :
Me.cboPort.RowSource = "SELECT PORT.PORT_ID, PORT.PORT FROM PORT " & _
" WHERE CNTRY_ID = " & Nz(Me.cboCountry) & _
" ORDER BY PORT"
Me.cboPort = Null
PORT to CARRIER:
Me.cboCarrier.RowSource = "SELECT PORT_CARR.PORT_ID, PORT_CARR.CARR_ID FROM PORT_CARR " &_ " WHERE PORT_ID = " & Nz(Me.cboPort) & _
" ORDER BY CARR_ID"
Me.cboCarrier = Null
PORT to CARRIER is where the problem is.
It populates the combo box, but with the ID numbers instead of actual CARRIER names.
(the Junction table are two PK fields and are lookups to PORT in PORT table and CARRIER in CARRIER table.)
Is there a magic spell for cascading combo boxes when you hit a junction table?
View 14 Replies
View Related
