Report question

[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.

 

[Guest]

SELECT Evaluations.EvalDate, Evaluations.StudentID, Avg(Evaluations.Physical)
AS AvgOfPhysical, Avg(Evaluations.Emotional) AS AvgOfEmotional,
Avg(Evaluations.Spiritual) AS AvgOfSpiritual
FROM Evaluations
GROUP BY Evaluations.EvalDate, Evaluations.StudentID;