more league table help

  • Thread starter Thread starter Phoenix_fiames
  • Start date Start date
P

Phoenix_fiames

ok i am trying to set up a league table for my local pool league, i have all
the teams sorted by points and then by framediffence which works perfectly
but now i want to ad a field simply with league poositions 1 to 15,

i was given this tutorial -
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=309

and this has helped a little, what i have now is a table that looks at the
points only, because there are some teams that have the same points it is
giving equal firsts equal tenth etc,

what i would like to know, is there a way of making it look at the frame
difference field as well as the points field?


this is my SQL code so far:


SELECT

(Select Count(1) FROM league_table T WHERE T.Points >league_table.Points)+ 1
AS League_Position,

league_table.Team, league_table.Played, league_table.Won,
league_table.W_Draw, league_table.L_Draw, league_table.Lost,
league_table.For, league_table.Against, league_table.Frame_Difference,
league_table.Points


FROM league_table


ORDER BY league_table.Points DESC , league_table.Frame_Difference DESC;


thanks
Phoenix
 
Back
Top