assign a autonumber value records returned in query

  • Thread starter Thread starter Randal
  • Start date Start date
Lots of us do. It is generally done with a subquery:
Select Score, (Select Count(*) from tblScores s Where
s.Score<=tblScores.Score) as Rank
FROM tblScores;
 
Thanks Duane. I am still not sure I get it. I am getting the rank returned
that the field had in the original table. What I would like to see is the
rank in the current query results.
 
It might help if you provided some information about your table/query and
fields. I'm not sure how you expect anyone to assist with the lights being
turned out. We can only guess.
 
This actually worked for me after I understood that it is ranking based on
contents of the field in the sub query.

Thanks again.
 
Back
Top