Number accordingly. 1

[lars7]

Hi there,
I have a list in my report that I would like to put a number in according to who has the most points ie:

No. Total.
1 89
2 78
3 45

and so on.
Can anyone help me with this.

 

[kjv1611]

Need some more detail.

Where is the data comming from? Any other info you can provide?

 

[lars7]

Hi Kjv,

The Info. comes from the following SQL:

SELECT tblPlayer.PPlayerId, tblPlayer.PPlayer, Sum(qryGameScore.QPoints) AS Total FROM tblPlayer INNER JOIN qryGameScore ON tblPlayer.PPlayerId=qryGameScore.GPlayerId GROUP BY tblPlayer.PPlayerId, tblPlayer.PPlayer;

I would like the names of the players to be displayed in order ie: the person with the most points at the top of the list and a number listing them at the side. I hope this makes it clearer.

 

[dhookom]

Use the sorting and grouping dialog to sort your records. Then add a text box to your detail section:
Control Source: =1
Running Sum: Over All


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lars7]

Thanks dhookom,
that's exactly what I was looking for.

Tom.