Prev: ranking players in a competition
Next: Ten calendar harm one of the products
From: JOSELUIS on 10 Feb 2010 18:05
HI MY NAME IS JOSE LUIS FROM SPAIN I´M A ROCKIE IN ACCESS.I CREATE A ACCESS
DATABASE FOR A SPORT COMPETITION.
IN A QUERY I CREATE :
PLAYERID/PLAYERNAME/TEAM/MARK
BUT I NEED TO RANK ALL THE PLAYERS IN EACH TEAM.
WHY? BECAUSE ONLY THE THREE BEST PLAYERS IN EACH TEAM ARE TAKING INTO ACCOUNT
IN THE TEAM CLASIFICATION THEREFORE THE PLAYER WHOSE MARK IS HIGHER WILL BE
1º AND SO ON UPTO 3º AND TEAMMARK= SUM(MARK) IF RANKING= 1º,2º,3º
SORRY FOR MY ENGLISH AND THANK YOU IN ANTICIPATION.

 | 
Pages: 1
Prev: ranking players in a competition
Next: Ten calendar harm one of the products