check query if records are the same

[rwahdan1978]

Hi

I have a query:

Dim rs As Recordset
        Set rs = CurrentDb.OpenRecordset("select * from users order by score desc")

I want to check if there are equal scores for all records. Say I have score of 100 3 times and score of 70 for 2 times, I want to know which records have the same score?

rec 1 score 100
rec 3 score 100
rec 7 score 100

rec 88 score 70
rec 120 score 70

how to acheive that?

[June7]

Sort records by score. Display on form or report.

If you only want to show records that duplicate a score, i.e. exclude singles, that is another matter and requires nested query. Or some fancy VBA code behind report.

[rwahdan1978]

Sort records by score. Display on form or report.

If you only want to show records that duplicate a score, i.e. exclude singles, that is another matter and requires nested query. Or some fancy VBA code behind report.

I am making compitition app and i need to check if I have a tie between players then I will make a new round of questions for those who have the same score so i can get the winner.

[June7]

Doesn't alter my answer.

Although I expect need more sort criteria, such as EventID, etc. Not knowing your db, hard to say.

[rwahdan1978]

I have this query it getting each score and how many times but I need to include the UserID as well how to do that?



here is the screenshot, I need to know which userid is having that number?

[June7]

An aggregate query alone is not going to accomplish. And would only be useful as a nested query to limit results.

Easiest is to just sort records.

Or build a report and use its Sorting & Grouping features.

Or use VBA like http://allenbrowne.com/func-concat.html