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.
 
You must log in or register to reply here.

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 do I make a query return just 1 record 2
returning only a selected number of records 1
query that brings a autonumber field 6
Trouble with Query Results 11
A simpler way to do a pseudo-autonumber in a query 4
Return Zero if No Records 1
Query that autonumber some columns 3
Append Queries 5

Back
Top