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)
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?)?
Is it all possible to create the equivalent of a combo chart in Excel in Access?
What I need is a graph showing a certain dataset as columns but also a line showing the average for that set.
As an example lets take an exercise programme in a school, each child performs a series of exercises every week and data is recorded, to monitor their fitness progression.
Lets say I wanted to show a graph of one particular exercise, with the class students listed along the x axis, and then show the class average for that exercise dataset as a line on the same graph.
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.
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.
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...
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.
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..
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:
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?
I`ve searched the forums, but not knowing the terminology, i cant find what I`m looking for.
I have a table which is use for a drop down list in my forms. This is saved into a table, but shows up as a numerical instead of the name value.
Also In reports, I get a numerical value, instead of the text value.
Is there something I`m over looking ? Or am I doing something totally wrong. My relationships are correct. and the field data is right, I just cant over come the number issue.
I modified some reports in my music library database to have the composer first name and last name appear as one field. I'm not sure what is wrong with them, and request another pair of eyes look at them to see if the error(s) can be found. Please bare with me, this is my first post to this forum so I'm not sure if I am following the rules correctly, yet I have posted to the Java area before. I'm not sure what I should include for help, since when I try to include my database in *.zip format, it is saying it is too big to send. Any ideas on what I should send?
I have a query that runs - off the back of this, a report. The query will show a name eg dave however the report will show Daves unique key (eg 3) and not just say dave how do I sort this?
I have a list of departments, 1-17, where each needs a SUM of their price for each end of day.
At first I was going to make 17 queries, and place each into a new sub-report, but there must be a way to list all 17, even if they haven't had a sale put through.
I've tried linking using "show all values in tblDept and only those that match in tblOrder" - but I cam across a very obvious issue.
The items are grouped by Z1 Number, a unique number for the end of day sales. If there is no department linked to a Z1 number, then it won't show it. For example, if there were no sales in dept01, then there is no record under tblOrder to show a Z1 number for dept01 - so there is nothing to link to in the report.
I was then thinking of creating false data at the end of day so the Z1 number mentioned each department at least once, but that would get messy and not 'normal'
I'm thinking of a type of loop to generate the report so a 17 row report is generated,
I have a bunch of records that are assigned to categories which are problem tickets. I would like to print the report showing not just the categories that have records open in them now, but also ones that don't have any records in them. So say I have these three categories. Power, Circuit, Hardware failure..If I have a few open tickets in circuit and hardware failures and none in power. Power will show show up on the report but with no records listed underneath it.
However, the data is now showing on the generated invoice.The rest are showing up but one.I went back to the tables to check and there is data present.It used to work until recently.
I have a main report with one subreport. The main report contains details of a payment being made to a supplier. There is the total amount being paid, and the cheque number being transferred. There is also a field called payref which is made invisible. This is used to link up with the subreport. The amount is the total of several invoices for which payment is being made.
The subreport contains details of each of a number of the invoices being settled. The subreport is linked to the main report via a common field called pay-ref, and the subreport is 'visible'. The subreport prints when placed in the page header section of the main report. However when there is a large number of invoices being shown in the subreport only a certain number appear. It appears that the subreport can only hold a certain number.
When the subreport is put, as it should, in the detail section of the main report, it does not appear at all in the main report. I have no clue why and I have made several reports like this one before.
I have a REPORT containing 7 ('columnar') subreports. Each subreport is to show showing a days worth of medical doses.... to visually represent a wall planner.
When the report loads - user enters a week value # via Inputbox(). This value is written to a TEMP table. Each subreport accesses this same TEMP table to retrieve the week # value. In the Recordsource for each subreport I have the following code :
SELECT * FROM GETPATIENTREADINGS_WEEK WHERE (((Format([DateR],'ww'))=DLookup("WeekVal","[TEMPTABLE]")) AND ((GETPATIENTREADINGS_WEEK.DayVal)=1));
... where the DayVal goes from 1...7 corresponding to the columnar position of each subreport on the display ie. for each day of the week.
The problem I am having is that when the report runs - I see the display showing the data from when the report was previously run. ie. I have to run the report twice to see the data for the correct week value entered. All the SQL works as expected when I run from Query view but when I run through VBA..
On design, layout and report view, everything looks exactly how I want it. However, when I display it in Print Preview mode, checkboxes appear about the Project Name.There's nothing in my report to show that I have these checkboxes on the report. Where these could be coming from and why they only show in the Print Preview layout?
I tried using an IIF statement in a text box in the mainform branch header section to return the branch expense if subform branch = mainform branch.......When I run the report I get all of the Employee overhead but only the last record for Branch 2 branch expense displays.
I created a Report from a query. The query shows the correct data that should be on the Report. I created the report to sort by Field A and then sum Fields D, E, & F. None of the query data shows up on the Report. I;m stymied as to why I can see data on a query, but the ONLY data that shows up on the Report is Field A. None of the summations show. All are blank with the box outline.
I've created the report 3x thinking I did something incorrect. Whatever it is, I did it 3x!
I'm working with a report that totals the number of times a topic is returned from a query. If a topic is not returned at all, i don't want it to show at all. Currently it is showing a blank field for that topic name and blanks in the count as well. Here's the filter i've put in to pull the right data out of my query: =Sum(IIf([Caller Used Resources]="No",1,0))
The first is my table of pupils which is linked to the second table: a list of awards and a score 1-5
My third table is the list of 10 awards.
My problem is that (in my report) I want to show all 10 awards for each pupil regardless of if they have achieved them. I'm struggling with the underlying query to always show all 10 awards.
So, little Johnny has achieved a score of 5 in two of the awards, however the report card will show blanks for the remaining awards on his report.