Formulas needed for report

[Lindros]

I have a database that I'm creating for someone else. Here's the deal: They have a list of employees and a set of questions that have a range from 1 to 5. I have all that set up in a form with drop down lists to choose the employee and the ratings for each question.

They want a monthly report that will tell them the average information for each employee. So for Jane Doe they want a report for each month that gives an average for each question so they know how she rated. Then they want an average for all the questions at the bottom. So if she averaged 5 for half of the 10 questions and 3 for the other half, her total average should be 4.

Anyway, I know how to get an average for each question, but I don't know how to make the average for each question per employee and then how to do the total average.

Thanks!!!

 

[ComputiVerse]

can you use the report wizard and group by question and within that group by employee? When you get the group hiaracy like you want, just tell the wizard you want avgs, sums, and all that stuff.
I have found the wizard is really powerful, but you have to keep your eye on the ball.
Johnstown, OH
JDC@wsprog.com