How To Average Scores

Mar 9, 2008

First of all I consider myself to have Intermediate knowledge of Access. I am comfortable building tables, queries, reports, macros, etc. but get a little lost when needing to manually code something in a query.

I need to create a database to document quality reviews of certain reports the plant creates. Typically each report gets reviewed by 2 to 6 people and each section is scored. So lets say the database table has the following fields

Report_No
Reviewer_Name
Review_Date
Section1_Score
Section2_Score
Section3_Score
Total_Score

I need a query that will average each of the Section Scores and Total Score so I can build a monthly report showing the report and the average grade for each section and the average total grade.

Any suggestions on how to do this is appreciated.

Thanks,
Jim

View Replies


ADVERTISEMENT

Baseball Scores

Aug 22, 2006

Hello All,

Trying to make a softball database. Have the tables as:
tblPlayers
tblGames
tblTeams
tblTeam_Players
tblStats

Anyays, having problems with making a games win/lose querry. In my tblGame I have the following

GameID
Date
Time
HomeTeam
AwayTeam
HomeScore
AwayScore

What I am trying to do is write a querry that will give me the win lose record of all the teams.

Problem is I can get the total for Home and totals for away, but not both at the same time.

What I am looking for is something like:

Team wins loses
Cleveland 15 1
New York 10 6
Altanta 5 10
Chicago 6 9

etc...


I am an experienced in access but limited on SQL.

Any help?

Thanks

View 4 Replies View Related

Creating Database For Test Scores

Jun 16, 2015

I am looking to create a database that collects data from past tests, predict probable future score, and compare to goal score. Currently I am studying for the Bar Exam and want to track (in all 7 subjects):

-my current scores for practice exams
-prediction of what my score will be on exam day
-comparison of actual and goal score
-comparison of predictive and goal score
-all of the above, separated by different types of Tests for each subject

Below is an example of the type of data :

Ex: Civil Procedure--06/15/15-Kaplan questions-> 6/10 (60% practice score)-> (predict gain 1 point 70%)-> (actual exam goal 20/28=71%)
Civil Procedure --06/15/15--past MBE questions->7/10 (70% practice score)->(predict gain 1 point 80%)-> (actual exam goal 20/28=71%)

Also from this data I want to generate graphs

Would this be possible in Access? Should I use excel instead?

View 5 Replies View Related

Student Scores Display In Multiple Columns?

May 9, 2015

how can I display the scores of a student in horizontal?

I have two tables, one with students information and another for students' score.When I query may table using this

Code:

SELECT Student.StudentName, WrittenScores.Score
FROM Student INNER JOIN WrittenScores ON Student.[ID] = WrittenScores.[StudentID];

It resulted to this

All I want to do is something like this

View 14 Replies View Related

Queries :: TOP N Subquery (Scores) For Each Member In Race League

Jan 5, 2014

I have a race league, I want to select the top 10 point scores for each member.

I have read the Allen Browne article (and many others) and tried many variations on his code but cannot get this working.

I face two issues
- The ORDER by clause has no effect, points are not sorted with largest first
- Access being unable to differentiate between scores with the same value and returning additional records. I have added an "Event" field to make the record unique, but this does not seem to work.

Query code is

SELECT qLeague.Member, qLeague.Event, qLeague.Points
FROM qLeague
WHERE qLeague.Points IN
(SELECT TOP 10 Points
FROM qLeague AS Dupe
WHERE Dupe.Points= qLeague.Points
ORDER BY Dupe.Member, Dupe.Points DESC
)
ORDER BY qLeague.Member ASC, qLeague.Points;

This returns more than 10 results per member:

Member Event Points
Alex Peters SDMC North Weald Sprint 3
Alex Peters HCAAC Debden May 3
Alex Peters GB/Harrow TAMS NW Sprint 4
Alex Peters HCAAC Debden Sprint 5
Alex Peters Llys y Fran Hillclimb 6

etc ....

View 10 Replies View Related

Generating Scores Based On Number Of Tick Boxes?

May 3, 2012

I am wondering if it is possible to calculate scores automatically based on the number of tick boxes the users have selected? If yes, how do I go about doing this feature?

View 5 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

Risk Assessment Database - "rollup Risk Scores" From Workstation To Department...

Jan 3, 2008

I don't know if it'll make sense out of context like that.

I am working on a Risk Assessment database, where a factory can be assessed to see which risks exist at workstations/departments or the whole facility.

So Assessments can be either a Workstation, a Department or a Site level.

Within each assessment there are multiple risks, each of which receives a numeric "score" (assigned by assessors). Let's say that it's 1-100 scale.

I need a way to "roll up" (or summarize) the scores, so that the whole assessment can display a "total" risk score. But it's not just adding up of the individuals - there are "weighting" multipliers we use, because we want to emphasize high risks.

Also, multiple workstations' rollup Score needs to "roll up" to their department, so that a department's score is "made up" of individual workstation scores. Also using the same weighting multipliers.

Then, the departments are rolled up to the whole facility.

The database has a table of the weighting multipliers so if a Risk Score is 75 or higher, it's to be multiplied by 10, 50-75 - multiply by 8 and so forth.

I can't come up with a way to do this through queries or code.

thanks!

View 12 Replies View Related

Average

Jan 11, 2008

I have a query that finds an average. How can I get the average to only show two numbers after the decimal?

View 4 Replies View Related

Average

Dec 10, 2005

I apologise for my ignorance, but I’m very new to Access.

I have a database of dates, that I need to analyse.

I have created a Form called "DateRange" with 2 date fields;
Text1 = Date From
Text2 = Date to
Command1 = Preview Report

My Query has 2 fields;
Slotdate = all the dates (show as 20051210)
Actdur = Actual Duration (show as numbers 1 or 12 or -3 etc)

The SQL View is;
SELECT slotapp.slotdate, slotapp.actdur
FROM slotapp
WHERE (((slotapp.slotdate) Between [Forms]![DateRange]![Text1] And [Forms]![DateRange]![Text2]));


I just want to calculate an average of Actual Duration
So that my report displays the average duration between the date ranges.

Any assistance in this matter would be greatly appreciated

View 1 Replies View Related

Best 5 Day Average

Oct 2, 2007

I've looked thru a lot of posts, but can't seem to find the solution. It seems like this should be something I could figure out, but so far have not.

I have a table that is showing a production number for each day. What I'm trying to show is the best 5 day average production over a period of time.

Thanks,
Tom

View 4 Replies View Related

Age And Average

Feb 18, 2005

Could someone please tell me how to work out the age of someone using a query or report and the average age of everyone?? I also need to know how to put on a report the total number of people satisfying the search criteria. It also says i must obtain a single record for each person and to do this i need to change a query property to allow only unique records to be displayed? do u know what this property is??
Please help!!
Thank You

View 6 Replies View Related

Rolling Average

Sep 15, 2005

Is there any way i can calculate a rolling average for a field in a record, based on the 10 previous records?

Cheers,
Ben

View 3 Replies View Related

Finding An Average

Aug 8, 2007

I have a customer concerns database that contains the dates for when the concerns were reported and tyhe dates for when the concerns were resolved. I am trying to make a query that finds the average of how long it takes for the concerns to be resolved. How can I do this?

View 1 Replies View Related

10-min Average Query

May 3, 2006

Hi,

I'm trying to create a query that returns 10-min average wind speed.

I have the logging date,time and the wind speed per second in the wind log table.
Date and Time Wind Speed(mph)
28/04/2006 2:17:01 PM 10.5
28/04/2006 2:17:02 PM 10.6
28/04/2006 2:17:03 PM 10
...

And I would like something like this from the query:
Date and Time Wind Speed Ave
28/04/2006 2:17:00 PM 10
28/04/2006 2:18:00 PM 7
28/04/2006 2:19:00 PM 5
......

Thx,
1.8T

View 5 Replies View Related

Average Time Per Day

May 21, 2007

i have a date field with time and date each record is entered. results look like this

Date_Complete
4/9/2007 8:26:11 AM
4/9/2007 8:31:25 AM
4/9/2007 8:34:14 AM
4/9/2007 8:34:21 AM
4/9/2007 8:34:29 AM
4/9/2007 8:34:36 AM
4/9/2007 8:34:49 AM
4/9/2007 8:41:27 AM
4/9/2007 8:41:49 AM
4/9/2007 8:42:32 AM
4/9/2007 8:42:39 AM
4/9/2007 8:42:49 AM
4/9/2007 8:43:36 AM
4/9/2007 8:44:21 AM
4/9/2007 8:45:48 AM


I want a query or report to give me the average entry time per record. Something like: Average time between orders 1:25 (one minute twenty five seconds)

View 2 Replies View Related

Running Average Of 5

Sep 26, 2007

I want to create a running or moving average of the most recent 5.

can anyone help here?


see attached file

Mix IDTest Date 7 Day1 Avg of 5Ave 28 Day
SF227
2/1/2007 3870
2/1/2007 2160 5415
2/7/2007 3580 5505
2/7/2007 3510 4955
2/12/2007 2990 32204965
2/19/2007 2800 30085500
2/19/2007 3330 32424920

View 2 Replies View Related

Find Average

Jan 2, 2008

I need to make a query which counts the number of days between "Date of Complaint" and "Effective Date". This is what I have so far:

[SELECT [Customer Complaint Log].[Complaint Number], DateDiff("d",[Date of Complaint],[Effective Date]) AS Expr1
FROM [Customer Complaint Log]
WHERE ((([Customer Complaint Log].[Effective Date]) Is Not Null) AND (([Customer Complaint Log].[Date of Complaint]) Is Not Null));



I need to make it so that it uses todays date for "Effective Date" if there is no "Effective Date". Any help would be appreciated. Thanks.

View 3 Replies View Related

Rounding An Average

Jan 15, 2008

I am running a query that returns the minimum, maximum, and average mileage of a list of cars. I have set decimal places to zero in all places I can think of, but of course the average returns with a long decimal output. These figures are then displayed on a report.

How can I truncate the 'average' display so it rounds to show no decimals?

I have tried using Round([YourNumberFieldName],3) in the query but that doesn't seem to work.

The numbers are stored in a table as double numbers. Again the decimal places are set to 0.

Thanks.

View 2 Replies View Related

Average Of A Group

Jan 29, 2008

I have a file with hundreds of home builders. It has three fields for this problem.
Table = Permit
field = Per_date (Date Field) Date BLD record appears in table.
field = BLD (Char) Builder number or Name
field = SQFTArea (N) Size of home.

1. I need to be able to get the average for (SQFTArea) for all records greater than 950 (SQFTArea).
2. For year 2007.
3. Grouped by Builder (BLD).

Example: Per_date - BLD - SQFTArea
Record: 2006 - 012 - 0500 Not becouse of 2006 and 0500
Record: 2007 - 012 - 2500
Record: 2007 - 012 - 3500
Record: 2007 - 058 - 2000 Not becose of BLD=058
Answer is for 2007 BLD 012 has an average of 3000


BLD 058 would be figured with it's self at average=2000 if the only record with this number or used with any other records that are BLD 058.

I have asked for help in the past but must likely my examples not that great. Here’s hopping. Hopping?? I hope I got that right being as I'm not a rabbit. Spell checker no help on this one.

Bob

View 2 Replies View Related

Quarterly Average

Dec 7, 2004

I need help with a calculation in my form. I have a form named families. IN this form I have 12 check box's, one for each month. I would like to set up another box which would take the average of the past 3 months and tell me what percentage of the time the box is checked. For example, since it is december, I would like a box named quarterly average to look at the past 3 months, obviously september, october and november, and tell me in percentages what the percentage is that the past 3 months check boxes have been checked. This is the basic code which I created for my unbounded box, but I want it to be dynamic, so that it recognizes what the month is today and tells me automatically what the percentage is.

Control sourceis set to =Abs(([Sep]+[Oct]+[Nov])/(3))

Thanks,

Tim

View 3 Replies View Related

Average On Form

Jun 7, 2005

Good day,

I am looking to calculate a simple average of two numbers when my form loads(It appears to be a basic concept, but I cannot figure it out). I have tried to build an expression but this didn't show any value. =([score1] + [score2])/2
I have attached my db to view my problem. I am wondering if anyone can assist me with this.

Thanks

View 1 Replies View Related

Average, Mean, And Mode

Aug 24, 2007

Hi guys,

I know I can average data in Access, but is there a way to do mean and mode? As always, thanks all...

Caliboi

View 1 Replies View Related

Average Sum Needs To Be Displayed As Non Decimal

Apr 8, 2008

Hello,
I have a querie that calculates the average of two sets of times taken from a calculated figure in a table.
My problem is that the returned value seen when the querie is ran needs to be of a clock format. Eg 0.75 needs to read as 0:45
I have attached a Database to help, as i am unable to do this.
Any suggestions given i am greatful for.

View 3 Replies View Related

Simple Average Query

Jun 3, 2005

I apologize, I know this has been covered. But I just spent half an hour reading old posts and still can't quite decide how to apply it to what I'm doing.

I have a db that logs surgeries and all their details. One of the new things they want to do is be able to run a list of average cost for a certain surgery, since patients are always asking ahead of time how much it will cost. I have a query (and report that runs from it) that will list all the surgeries and total charges for individual ones for a date range the user specifies. But I can't figure out how to make it calculate an average charge for each surgery. I could if there were always a certain number to divide by, but of course there could be 2 of this type of surgery and 57 of that type.

The query I currently have set up is:

Field: MR#
Table: SurgeryLog

Field: Wname: [LastName] & ", " & [FirstName] & " " & [Initial]
Table:
Sort: Ascending

Field: OperationDate
Table: Surgery Log
Criteria: >=[Enter Start Date]

Field: PatientType
Table: SurgeryLog
Criteria: "SDS"

Field: TotalCharges
Table: SurgeryLog
Criteria: >0

Field: Operations: [Operation1Performed] & Chr(13) & Chr(10) & [Operation2Performed] & Chr(13) & Chr(10) & [Operation3Performed]


Thanks much!

View 1 Replies View Related

Average Time In Query

Dec 6, 2005

I have a query with the fields dtDate (Date/Time in Short Date format), NC "Number of Chats" (Long Integer), and TCT "Total Chat Time"(Date/Time in hh:nn:ss format) from tblChats. Each date will have multiple NC and TCT values. This query is totaling them by date with the following SQL.

SELECT DISTINCTROW tblChat.dtDate, Format$([tblChat].[dtDate],'Short Date') AS ChatDate, Sum(tblChat.TCT) AS SumOfTCT, Sum(tblChat.NC) AS SumOfNC
FROM tblChat
GROUP BY tblChat.dtDate, Format$([tblChat].[dtDate],'Short Date')
HAVING (((tblChat.dtDate)>=Date()-7))
ORDER BY tblChat.dtDate;

The query works fine. Now my question.

I would like the query to figure the average time per chat for each day.

Could this be done without VBA? Any ideas??

Thanks.

View 3 Replies View Related







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