See if this gets you something workable:
SELECT Table1.*, IIf([F1]=[MaxOfF1],1,0)+IIf([F2]=[MaxOfF2],1,0)+IIf([F3]=[MaxOfF3],1,0)+IIf([F4]=[MaxOfF4],1,0)+IIf([F5]=[MaxOfF5],1,0)+IIf([F6]=[MaxOfF6],1,0)+IIf([F7]=[MaxOfF7],1,0)+IIf([F8]=[MaxOfF8],1,0)+IIf([F9]=[MaxOfF9],1,0) AS Wt
FROM Table1, (SELECT Max(Table1.F1) AS MaxOfF1, Max(Table1.F2) AS MaxOfF2, Max(Table1.F3) AS MaxOfF3, Max(Table1.F4) AS MaxOfF4, Max(Table1.F5) AS MaxOfF5, Max(Table1.F6) AS MaxOfF6, Max(Table1.F7) AS MaxOfF7, Max(Table1.F8) AS MaxOfF8, Max(Table1.F9) AS MaxOfF9
FROM Table1) AS Query1
ORDER BY IIf([F1]=[MaxOfF1],1,0)+IIf([F2]=[MaxOfF2],1,0)+IIf([F3]=[MaxOfF3],1,0)+IIf([F4]=[MaxOfF4],1,0)+IIf([F5]=[MaxOfF5],1,0)+IIf([F6]=[MaxOfF6],1,0)+IIf([F7]=[MaxOfF7],1,0)+IIf([F8]=[MaxOfF8],1,0)+IIf([F9]=[MaxOfF9],1,0) DESC;
F1 is the first data field - primary key is in field ID