Sequential Numbering

  • Thread starter Thread starter Trevor Da Costa
  • Start date Start date
T

Trevor Da Costa

I have a report that pulls numbers from a form and should
display them in order, e.g

Pos: Name Score

1 John 80
2 Bill 81
3 Tom 84
3 Ben 84
5 Mary 86

Any ideas how I can have the Pos: field displays ties as
above?
 
You could do this in the query with a subquery
SELECT Name, Score,
(SELECT Count(*)+1 FROM tblA A WHERE A.Score<tblA.Score) As Pos
FROM tblA;
 
Back
Top