Reports :: Calculating Average From Checkboxes?

Mar 6, 2014

I have a report that I'd like to create a scorecard within. The scores will be expressed as percentages. I have 8 categories of tasks, and each category has a differing number of activities within it. When an activity is completed, the user checks a box indicating it is done. So I'd like to calculate the percentage of a category.

I've tried creating a control that has =Abs([Task_1_1_Flag]+[Task_1_2_Flag])/2 in the On Update and On Enter to just calculate the percentage on the fly when the report is accessed, but the field is blank when loaded despite 1 of the 2 checkboxes displaying as checked on the report. The percentages don't necessarily need to be stored in the table, but could be if that's easier.

View Replies


ADVERTISEMENT

General :: Staff Table - Calculating Average Weekly Hours

Mar 4, 2015

I have a table with staff in.

I have a table with the start and end of their shifts.

We have four possible locations and four weeks.

So I have four tables for each location.

I have a module that can work out hours and deductions based on time in and out. I built that into a seperate databse working on a one time in and one time out setup.

I want to incorporate the two so I can get the hours worked over four weeks at all locations and divide that by 4 to get the average weekly hours for a staff member.

View 8 Replies View Related

Reports :: Showing Up To 28 Day Average?

Jul 22, 2014

What I am thinking of is to have a fairly simple table, as follows:

Date
Supervisor Name
Day type (Sat, Sun or Weekday)
Duty Number (combo box, looked up from a separate small table)
Time Start (auto-completed based on Duty Number)
Time End (auto-completed based on Duty Number)
Target A (which would be a number such as 1.20 or 0.90)
Target B (which would be a percentage such as 85.00%
Result A (same format as Target A)
Result B (same format as Target B)

Restriction (whole number, no decimal places)
Output 1 (percentage)
Output 2 (percentage)

Then have a report that shows each day's data for each day worked, with a set of text boxes at the bottom of the page in the footer area most likely, that show the average of all Target, Result, Output and Restriction fields for all the dates shown on the report.

It would be most likely to be ran for a 7 day period or a 28 day period, but if it could be made able to cope with any number between the dates specified at the time that the report was being pulled, that would be ideal.

Is this possible, and what would the code be to get a field to calculate the averages at the bottom (I presume that this code would have to be different to handle the decimals or the percentages?)?

View 2 Replies View Related

Creating Reports On The Fly Via Form Checkboxes

Apr 5, 2006

I have been searching and searching for a solution to this problem, but have been coming up short.

I have a database which lists tests done on certain products. Each product requires different tests, so it is not feasible to make a static report for each product.

My problem lies in creating a report which has the product name and number at the top of the report, and below that, I want to list test results based on information passed from a form through checkboxes. I really am not sure how to create this report because the tests change with each product, so I cannot include static headers for each test.

The way my form is set up is I have the Product Name/Number at the top, and right below that are several checkboxes which are named after each test. I want the data from these tests to populate the report.

Any help would be greatly appreciated!

View 3 Replies View Related

Creating Reports On The Fly Via Form Checkboxes

Apr 5, 2006

I have been searching and searching for a solution to this problem, but have been coming up short.

I have a database which lists tests done on certain products. Each product requires different tests, so it is not feasible to make a static report for each product.

My problem lies in creating a report which has the product name and number at the top of the report, and below that, I want to list test results based on information passed from a form through checkboxes. I really am not sure how to create this report because the tests change with each product, so I cannot include static headers for each test.

The way my form is set up is I have the Product Name/Number at the top, and right below that are several checkboxes which are named after each test. I want the data from these tests to populate the report.

Any help would be greatly appreciated!

View 1 Replies View Related

Reports :: Take Total Of Columns And Get Average

Jan 13, 2015

I have two columns in my report that at the bottom it gives me the following total, as I put below. I am trying to take the two totals that is gives and get the percentage. 1058/3024 = 35%.

=Sum([TotScrwBlank]) =Sum([TotalAmount]) .349 or 35%
1058 3024

I had did the equation as =Sum([TotScrwBlank])/([TotalAMount]), but this is giving me the answer of 46% which is not correct.

View 3 Replies View Related

Reports :: Average Of Time In Minutes And Seconds

Feb 7, 2014

Basically, I get daily reports from the client and the AHT and ACW values come in seconds. I've recently added code to the query changing the data to nn:ss which works perfectly. Below is some info:

tblTelephony
[AgentName]
[Calls] (number of calls answered)
[AHT] (in seconds)
[ACW] (in seconds)

[Code] ....

The above code works very well, where I'm stuck is in the attempt to average the fields [AHTMinSec] & [ACWMinSec] by Agent in a report.

Using [AHTMinSec] as an example:

I have the daily values for each agent [AHTMinSec] in the detail, Avg([AHTMinSec]) in the Agent group footer showing each agent's average, Avg([AHTMinSec]) in the Team group footer showing team averages and Avg([AHTMinSec]) in the report footer showing the campaign average including all teams. When I run the report the details are hidden providing each agent's average, the team average, and the campaign average.

The report worked just fine until I converted to minutes with the above code. Is there a reason that I'm getting an error stating that the calculation is too complex? I've done enough research to determine that the db can't Sum in order to average...

View 12 Replies View Related

Reports :: Calculate Average For Each Column / Expression?

Jul 4, 2013

I have a report that comes from a query with multiple expressions. The expressions look something like this:

IIF([TimeArrive]>[TimeTriage],DateDiff("n",[TimeArrive],[TimeTriage])+1440,DateDiff([TimeArrive],[TimeTriage]))

This works great and my report gives me my columns for each expression in minutes they way it should. Now here is the question...is there a way to insert a text box for each column/expression so I can calculate the Average for each column/expression?

i.e. I want the report to show the average minutes of Expr1 and Expr2, etc at the bottom of each column.

View 2 Replies View Related

Reports :: Average Of Numbers - Show Only 1 Record In Report

Sep 11, 2013

I have a report with 3 fields in it. I have made the control source for each field an average of the #'s in the field of the query. I only want it to show 1 record but can't seem to figure out how. I've already listed the cycle option to current record, but it still shows the 3 fields repeating over and over... for ex:

Field 1 Label 7.4
Field 2 Label 8.4
Field 3 Label 6.4

Field 1 Label 7.4
Field 2 Label 8.4
Field 3 Label 6.4

And it goes on and on like this... the averages are correct, but I only want to show them 1 time, not repetitively..

View 1 Replies View Related

Reports :: Can't Average Blocks Of Weighted Grades In Report

Aug 7, 2013

I'm having a problem getting a report textbox to display the average value that I want.

Background:I have a DB that tracks student grades. The course is organized into blocks, with several tests in each block. Students can take the same test multiple times, in cases of failure, or if they get rolled back in class. The DB tracks whether or not each test is a retest or audit.

The tests are also weighted. For example, the Geo Quiz could be worth 10% of the grade for a block, and the final exam 90%.

Goal:My report needs to display the class number, student name, block, test, and associated scores; it needs to show the total grade for each block; and it needs to display the student's average grade across all blocks. I need to be able to generate the report at any point in the course, not just after all blocks and tests have been completed.

Setup:Since I want to display the assigned grade, but calculate the weighted grade into the block grade, I set up a query (qryWeightedGrades) to calculate the weighted grade for each test (e.g. Score of 98%, weighted at 10% of block, results in a 9.8 for the weighted grade). When it comes to calculating the block grade, I just sum the weighted scores.

In the report (based on qryWeightedGrades) I have the grouping levels set up for Class#, Student name, then Block; the test name, score, weight, retake info, audit info, etc. appears together on a row.

How to do, get the average of all the block grades. I can't get the textbox in the Student Name group level footer to average the Block grades in the Block group level footer, without getting an error. I've thought of creating another query that averages the block grades for each student, but how to incorporate that into the footer of the Student Name group level.

Here's an example of what I want the report to look like:

Class#: 13010
Student Name: Smith, Peter
Block: WF101 (4 tests in block)
....Test: Quiz1, Score: 95, Weight: 10
....Test: Quiz2, Score: 90, Weight: 10
....Test: Essay, Score: 80, Weight: 40
....Test: Final Exam, Score: 85, Weight: 40
Block Grade: 85

[code].....

Student's average grade: 91.93 <--Getting this # is giving me problems

Class average grade: ##.##

View 2 Replies View Related

Reports :: Count Number Of Monthly Calls - Average Function In Footer

Jul 7, 2014

I have a report that counts the number of monthly calls. What I would like is an average of the monthly calls in the report footer.

My total for a particular month is =Count([Date]) and I named the unbound control MonthlyTotal.

This is in the DateFooter section of the report.

I then put an unbound control in the report footer and used the expression = Avg([MonthlyTotal]).

Of course when I changed from design view to report view, it asked me for an input of [MonthlyTotal].

I then tried =Avg([Reports]![qryLetterWritersbyDate]![MonthlyTotal]) and while it didn't ask me for an input, there was nothing in the ubound control in the report footer.

I have search for an answer, but all I find is using a query. Is what I am attempting to do possible? If so, how?

View 5 Replies View Related

Reports :: Calculating Incidents When A Value Is Less Than 3

Sep 9, 2013

I'm creating a simple delivery management database. I have created a query that calculates the time taken to deliver a package. However I need it to work out how many times it took longer than 3 days and just display the amount of times that this occurred. I'm using access 2003.

View 4 Replies View Related

Reports :: Calculating Values In A Report

Jul 29, 2015

we have a field in a report, and currently, there is a text box with a control source of

=IIf([Flag1]="Capital",[Reserve]-Sum([Text52]),"")

They want me to add to it, where if [Text106]="0",[Reserve]-[Text52], otherwise it's [Text106]="0",[Reserve]-[Text106].I am able to do this second part OK with

=IIf([Text106]="0",[Reserve]-[Text52],[Reserve]-[Text106])

But then I lose the [Flag1]="Capital" part.

View 4 Replies View Related

Reports :: Calculating Current Age In Years And Months

May 7, 2013

I am trying to calculate the age on the day the report is printed in Years and months ( and display it thus) in a report.e.g. 6 years 4 months

View 2 Replies View Related

Reports :: Calculating Sum (count) And Percentage Field

Jun 16, 2013

I am trying to work out the expression that will first count the number of 'Yes' returns in a series of yes/no boxes and then display as a percentage.

To explain...The yes/no boxes represent attendance over a 20 lesson course. I have added a count for each lesson for student attendance..(grouping them in the footer) but I would like to add the number of attendance for each student.

View 1 Replies View Related

Reports :: Training Records - Calculating Expiry Date Of Certificates

Aug 18, 2013

I am very new to access and I would like to pull some information from my tables.

I am using this for training records, I can calculate the expiry date of certificates using a query. What I would like is a report (even better an alarm of some sort) to show when things are due to expire. I can't seem to find this option as a report.Also, is it possible to have reports go into excel?

View 3 Replies View Related

Reports :: Average Contents Of A Field Based On Another Field

Oct 2, 2013

I have a report that has multiple fields - 3 of which matter for this discussion -

1.) employee
2.) employer
3.) rateofpay

The employer field contains 1 of 2 options. For the sake of this conversation, lets call it ABC123 and XYZ123

I need to be able to calculate the average rate of pay for ABC123 company, and exclude the rate of pay for XYZ123 company in my report.

I am calculating this in a section footer.

View 2 Replies View Related

What About This Average?...Field Average...

Feb 16, 2007

Hi guys!!!!

I try to find an answer in the forum about "Average Fields",but ican't
I am confused:(

I wan't to export Avg Of the fields like in the panel below:

View 2 Replies View Related

Checkboxes...

Jan 20, 2006

Any idea how I can display this information a lot neater?

Its a bunch of check boxes (I wasn't sure how to go about doing this without them, as they can choose multiple things, if it was just 1, I would have used a dropdown).

I've been trying to fiddle with this for a while now with no good ideas coming to mind.

Anyone have any ideas or examples of how I could go about this?

Thanks

View 4 Replies View Related

CheckBoxes

Jan 14, 2007

I am trying to use check boxes as a yes/no answer about whether members have completed training modules, and bind them to a table.

I get this error when tick the boxes, and try to close the form; "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. (Error 3022)"

When I reopen the form the check boxes are greyed out until i tick them (not getting values from table) :confused:

Any help appreciated :confused: :)

Matthew

View 1 Replies View Related

Checkboxes

Apr 11, 2007

I have a form that uses checkboxes to list all the fields in a table. How would I create a query based on that form?

For example -
Field Names - RMA_Num, Qty, Date_Rec, Part_Num, Desc, CC_Primary, CC_Secondary, CC_Tertiary, OF_Appearance

A user may choose to see Qty, Part_num, CC_Primary, CC_Secondary, and CC_Tertiary. How would I set up the query?

For testing I tried having RMA_Num, Qty, and Date_Rec in a query. I set the criteria for RMA_Num as IIf([Forms]![frm_meta]![Check0]=True,[tbl_Mfg_RMAData]![RMA_Num])

With the box checked the query will return results for all the fields. But if the box is unchecked the query returns nothing.

View 3 Replies View Related

Checkboxes

May 4, 2006

I have 4 check boxes represent 4 grade levels. When I click on a grade I have a query run for me a list of all 9th graders or 10th graders or both together.
When I run the form for the first time, all four boxes are check, when I unclick all of them and I click which ones I want the form does not work. But if I leave them click the report will work. Basically what is happening is when I unclick them, the lose their value.
I have the check box set up with a Default Value as "09" or "10" base on what Grade Level there is.
So my two questions are, how do I keep the value of the check boxes after I unclick and click again and Secondly, is there a way to have the boxes unchecked when I run the program?

View 10 Replies View Related

Checkboxes

Dec 14, 2006

I have form, with a number of orders on there, i wanted to be able to give the user the option to select all the orders and update each record, however when i give the user the option to seleect all the orders on the first line is updated. how can i get all the records to be updated the code i am using is shown below, any help will be greatly appreciated.


Dim db As DAO.Database
Dim String2 As Integer
Dim i As Integer
Dim rs As DAO.Recordset
Dim StrSQL As String

Set db = CurrentDb
Set rs = db.OpenRecordset("kell")

For i = 1 To Me.Quantity
Stringy2 = InputBox("The Cylinder/Cylinders Will Be with the driver
from The Specified Date Below:-", "Spec Gas 2006, (DD / MM / YY)", Me!Text68 & "")

If StrPtr(Stringy2) <> 0 Then
rs.AddNew
rs![Line Number] = Me![Line Number]
rs![Time of Transaction] = Me![Transaction Date]
rs![Cylinder Barcode Label] = Me![Cylinder Barcode Label]
rs![Cylinder Number] = Me![Cylinder Number]
rs![ProdNo] = Me![ProdNo]
rs![Status] = Me![Status]
rs![AberdeenWONumber] = Me![AberdeenWONumber]
rs![Works Order Number] = Me![Works Order Number]
rs![CustNo] = Me![CustNo]
rs![Customer Order Number] = Me![Customer Order Number]
rs![Date of Transaction] = Stringy2
rs![User name] = Me![User name]
rs![Employee ID] = Me![Empoyee ID]
rs![A Number] = Me![A Number]
rs![New Status] = "With Driver"
rs![Date of Transaction] = Me!Text68
Me.Text71 = "With Driver"
Me.Text71.ForeColor = vbRed
Me.Text74 = Me.Text68
rs.Update
MsgBox "The cylinder is now with the driver", vbInformation, "Returned Successfully"

End if
Next i

rs.Close
db.Close

End Sub

View 2 Replies View Related

Checkboxes

Jan 7, 2005

I have a database which uses checkboxes, however I only want my users to be able to select one or the other, not both.


How do I disable the second box when the first one is checked?

Thanks in advance

Kat

View 2 Replies View Related

Form With Many CheckBoxes

Jun 6, 2007

Sorry, but this is killing me. I can't find anything in the archive which directly relates.

And it's complicated. I'll try to simplify.

In a nutshell:

As I scroll each Employee on a Parent form, I'd like a subform with functionality to check off any Certifications earned by this person and write the EmployeeID and CertificationID to a junction table.

Seems to me it should be simple, but...


Anyway, here is the probably overcomplicated version here:

The one side tables are 1. Employees and 2. Certifications
The junction table records which certifications employees possess. This table contains some Boolean fields.

The Parent form knows the EmployeeID.

My goal is to create a subform on which to display the full list of Certifications, something similar to the attached image, with a button to add an EmployeeID to the junction table AND tick off the Boolean checkboxes.

I've based the subform on a query showing ALL Certifications and all (Junction) records where there is a match

Because the junction table only stores related Employees and Certifications as entered, the checkboxes on my subform cannot be bound directly to the fields in the junction table and, at the same time, allow me to check off the Booleans.

Perhaps a little db redesign? Any help greatly appreciated.

View 2 Replies View Related

Of Tabs And Checkboxes

Mar 15, 2008

Let me just start off by saying, I don't have any code to post as it is just an idea I have.

This is a Lease return project for work. We have an excel sheet that is broken up into tabs. Master List, Not Returned and then a tab for every month.

Here is what I would like to do.
If someone checks the box that says the leased computer was not returned, can I grab a certain batch of fields to automatically populate another Tab in this Access 2003 Form?

The second part to this would be if a person unchecks "Not Returned" in the Not Returned Tab, can I get that record automatically removed from that list view?

Similar principle for the Monthly shipping by a certain date. If the user enters in a shipped Date by say March 1, is there any way to populate a another tab into a list view?

Thanks for any advice that you gentlemen and ladies can provide.

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved