Sheehy, Design a new query. Use the table with the people/scores. Click
the View/Totals on the main menu. Add the scores field to your query. In
the Total row under the score field select Avg. Run the query. If you
wanted to do an average by person add the person field to the query. Under
it select GroupBy. Now it will give you an average per person. Hope this
helps.
--
Reggie
----------
"Sheehy" <an****@ihug.co.nz> wrote in message
news:ce**********@lust.ihug.co.nz...
Hi,
as part of my database i am wanting to input a number of scores that are
attributed to each person who is contain within the database.
How do i make it so i am able to show the average of the scores for the
people that i have input into the database.
Any help would be appreciated.
Cheers,
Matt Sheehy
