A SImple Position Counter

[tipster69]

Hi.

I have created a database to track players in our poker games and create a league table from the database.

I have done so by creating a main table with the player details in i.e date of birth, address etc. and a subform that stores player results, etc.

The league table is created using sum and count expressions and all is just as I wanted with the exception of something that I thought would be very easy to do but as of yet I have been unable to.

I want to add to the league a "POSITION" field because at present the players have to manually count down to find there position. I have posted an example of the report html below.

http://www.pokerresults.co.uk/forum/leagues/001/League Table 001.html

The end result of the League report is that it is exported as .html

Any help would be greatly appreciated.

THANKS

 

[dhookom]

You can add a sequence number on a report by add a text box to the 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]