Kamis, 14 April 2016

Re: [MS_AccessPros] RANKING

 

Duane,
 
I am very interested in your solution as it may be helpful to me also, but I don't understand it.
How does the "FROM tblAde A WHERE A.Score <= tblAde.Score" part work?
 
Dave W
 
----- Original Message -----
Sent: Wednesday, April 13, 2016 6:45 PM
Subject: RE: [MS_AccessPros] RANKING

 Ade,

The typical method using SQL like:
SELECT tblAde.StudentName, tblAde.Score, (SELECT COUNT(*)  FROM tblAde A WHERE A.Score <=tblAde.Score  ) AS Rank
FROM tblAde;

This doesn't account for your using ".5" for ties. Before working on any type of solution for this, we would need to know what this would like like if there is a 3-way tie or even more.

Duane Hookom, MVP
MS Access

__._,_.___
Posted by: "Dave Williams" <davewillgmale@gmail.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (9)

.

__,_._,___
Diposting oleh di

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)