Report with an average of ranking

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

Guest

Hi! I am stuck on a report I am trying to run. I have made a listing of
projects with priority rankings. My table looks like this:

Person Project rank1 rank2 rank 3 overallrank
1 1 2 4 3 3
1 2 1 2 2 2
2 1 4 3 2 3
2 2 2 1 1 1

I am trying to create a report that takes each person's ranking of each
project and runs an average for that project based on everyone;s rankings.
ANy help would be greatly appreciated!!!!

Thanks
Derek
 
I have a report now that uses a summary of the records but my question now
is. Is there a way to order my averages on the report since the summary is in
a footer?

Thanks
Derek
 
Back
Top