assign a autonumber value records returned in query

D

Duane Hookom

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;
 
R

Randal

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.
 
D

Duane Hookom

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.
 
R

Randal

This actually worked for me after I understood that it is ranking based on
contents of the field in the sub query.

Thanks again.
 

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

Autonumber field in Excel that behaves the same as Access 0
Adding data to MS Access from csv file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Report Group Footer DLookUp 0
Use TODAY() function as the criteria in a SUMIF formula 1
How do I make a query return just 1 record 2
query that brings a autonumber field 0
query that brings a autonumber field 6

Top