Query to break a tie

S

Steve S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to break a tie of fld A using fld B 4
Multi-level GROUP BY clause not allowed in a subquery 3
Ties using Rank Function 3
How to tie a record set to a form at run time? 4
Logic for tie breakers/ ranking 6
A macro that will break a link to another workbood 2
Where am I supposed to put this code for a page break? 3
Expression in a Query 2

Top