1st, 2nd , 3rd, etc
Question posted by: Peter Mitchell
(Guest)
on
July 13th, 2006 10:55 AM
I wish to rank records 1, 2, 3, etc according to the results of a query
My table name is Students with two fields StudentID and Score so I have the
following query (saved as Ordered) to put the scores in order.
SELECT Students.StudentID, Students.Score
FROM Students
ORDER BY Students.Score DESC;
1
Answer Posted
See:
How to Rank Records Within a Query
at:
http://support.microsoft.com/kb/208946/
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Peter Mitchell" <pmitchell@chariot.net.auwrote in message
news:44b61947_1@news.chariot.net.au...
Quote:
Originally Posted by
>I wish to rank records 1, 2, 3, etc according to the results of a query
>
My table name is Students with two fields StudentID and Score so I have
the following query (saved as Ordered) to put the scores in order.
>
SELECT Students.StudentID, Students.Score
FROM Students
ORDER BY Students.Score DESC;
>
>
|
|
|
What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 196,969 network members.
Top Community Contributors
|
