How To Average Scores

[jereece]

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

 

[DCrake]

Simple Software Solutions

Ok

Create a new query that groups by ReportId

Then add each section and choose Average from the options list, do the same for the total. I assume that the total is the line total for each report ID.

This will give you averages by reportid

CodeMaster: