Query to break a tie

Last summer (with the help of replies to my posts) I created a series of
queries, tables, crosstabs, and reports to display the results of a sporting
competition. We determined overall place based on total score which was a
rollup fron several subevents. we never experienced a tie because 3 or more
judges each awarded a a score from 0 to 100 to one decimal place (76.8)

Now the powers that be have determined it is best to rollup a competitors
'place', 1st, 2nd, 3rd... to determine final outcome. Now we have ties all
over the place. In one subevent at a recent contest we had 4 contestants
tied for 1st. since the subevent is rolledup to the overall sore we need to
break the tie(s) in the subevent rank (place).


I use the following in a query to determine place.

MRank: 1+DCount("*","tblRecapB","[Fee Id] = " & [tblRecapB].[Fee ID] & " And
AGSortKey = " & [tblRecapB].[AGSortKey] & " And MPP < " & [tblRecapB].[MPP])

Is there a way to modify this so that ties will be broken by looking at the
field "MScore" in tblRecapB? Or do I have to create a query to update MRank
(using the above) and then an additional query to look at MRank and MScore to
break the tie. If so How?

all help is appreciated