Have a calculated field in your Query to add those various scores.

Then sort descending on that calculated field in an Access Report.

HTH - Bob

Use a subquery to compute the Priority by counting the rows which have equal
or greater scores than the current row.  For the sake of simplicity the
following example uses only two columns Score1 and Score2:

SELECT Score1 + Score2 As TotalScore,
 (SELECT COUNT(*)
  FROM YourTable As T2
  WHERE T2.Score1 + T2.Score2 >=
             T1.Score1 + T1.Score2)
  AS Priority
FROM YourTable As T1
ORDER BY Score1 + Score2 DESC;

Note how the two instances of the table are distinguished by giving them
aliases T1 and T2, thus allowing the subquery to be correlated with the outer
query.

Ken Sheridan
Stafford, England