How to create a field showing numerical position within a table

[q582gmzhi]

Ideas For How to Create Report

Hi,

I am looking for Idea's of how to create a report.

Basically the report is a league table showing Month and YTD, this is the easy bit.

The part I need suggestions and guidance on:

The report also needs to show peoples movements in the league table i.e: whether they have moved up, down or not moved at all from the previous months position.

I was thinking of creating 2 tables: Current Month + Previous Month, in each table the persons position is indicated (an ascending record number is created throughout the table - not sure how to do this yet)

Then using code, lookup each persons position in previous month and write that position number against the persons UID and current position in current months table.

Am I on the right tracks or does someone have an easier solution?

Thanks in advance.

Darrell....

 

[q582gmzhi]

Hi,

I have created a query that creates a table.

The table displays people in a league based on a points system. The points system works fine, however I need to add a position for each of the people in the table. (something like autonumber down through the table)

Thanks in advance

Darrell..

 

[Smart]

If you create a report based on your table and sort it on the column containing the points (descending) then in your report create a textbox, on the properties on data on control source type the following =1
and on the running sum select overall

 

[q582gmzhi]

Thanks for the reply, but its a bit more in depth.

I need to create 2 tables one showing last months data and one this months data.

Give the records a sequential position in both tables and then create a report that shows the movement of the people in the report ie: move up, down or stayed in position from last month to this month.

Darrell....

 

[Smart]

I have attached a basic db that does what you want however you may have to tweak it a bit (sorry its only basic but may give you ideas

 

[q582gmzhi]

Thanks for the feedback, I will try and implement your suggestions

Thanks

Darrell...