Averages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a database for Student Evaluations. Each month our students
are evaluated by 12 staff members. I have a form set up so that the staff
members can go in and evaluate each student.
My problem comes on the report end of things. I need to be able to pull a
report that will give me the averages of the scores in each area for each
student. For example, one feild is Physical. There will be 12 scores under
physical for the month of October for student 1. I need to get the average of
those 12 scores. Is this possible?

Here is my table set up.
EvaluationID (number)
StudentID (number)
StaffID (number)
EvalDate (Date)
Physical (number)
Emotional (number)
Spiritual (number)

I have tied a query that sorts by EvalDate and StudentID.
Thank you for your expertise.
 
Create a totals query that groups by StudentID and
Format([EvalDate],"yyyymm") and then averages Physical, Emotional, and
Spiritual. Use this totals query as the record source for your report.

BTW: What happens when someone wants to begin evaluating based on a new
attribute? A properly normalized application would not require modify table
structures, report or form designs,...
 
Duane--
When I set my report up that way I got one page for each Evaluation. For
some reason the numbers aren't averaging together.

Duane Hookom said:
Create a totals query that groups by StudentID and
Format([EvalDate],"yyyymm") and then averages Physical, Emotional, and
Spiritual. Use this totals query as the record source for your report.

BTW: What happens when someone wants to begin evaluating based on a new
attribute? A properly normalized application would not require modify table
structures, report or form designs,...

--
Duane Hookom
MS Access MVP


RTimberlake said:
I am working on a database for Student Evaluations. Each month our students
are evaluated by 12 staff members. I have a form set up so that the staff
members can go in and evaluate each student.
My problem comes on the report end of things. I need to be able to pull a
report that will give me the averages of the scores in each area for each
student. For example, one feild is Physical. There will be 12 scores under
physical for the month of October for student 1. I need to get the average
of
those 12 scores. Is this possible?

Here is my table set up.
EvaluationID (number)
StudentID (number)
StaffID (number)
EvalDate (Date)
Physical (number)
Emotional (number)
Spiritual (number)

I have tied a query that sorts by EvalDate and StudentID.
Thank you for your expertise.
Click to expand...
Click to expand...
 
You should see the averages in the query. What do you see in the query? Are
you attempting to average across records or across fields?

What is the SQL view of your query?

--
Duane Hookom
MS Access MVP


RTimberlake said:
Duane--
When I set my report up that way I got one page for each Evaluation. For
some reason the numbers aren't averaging together.

Duane Hookom said:
Create a totals query that groups by StudentID and
Format([EvalDate],"yyyymm") and then averages Physical, Emotional, and
Spiritual. Use this totals query as the record source for your report.

BTW: What happens when someone wants to begin evaluating based on a new
attribute? A properly normalized application would not require modify
table
structures, report or form designs,...

--
Duane Hookom
MS Access MVP


RTimberlake said:
I am working on a database for Student Evaluations. Each month our
students
are evaluated by 12 staff members. I have a form set up so that the
staff
members can go in and evaluate each student.
My problem comes on the report end of things. I need to be able to pull
a
report that will give me the averages of the scores in each area for
each
student. For example, one feild is Physical. There will be 12 scores
under
physical for the month of October for student 1. I need to get the
average
of
those 12 scores. Is this possible?

Here is my table set up.
EvaluationID (number)
StudentID (number)
StaffID (number)
EvalDate (Date)
Physical (number)
Emotional (number)
Spiritual (number)

I have tied a query that sorts by EvalDate and StudentID.
Thank you for your expertise.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top