Sorting data in a table

[rolypoly]

I have a list of 22 soccer players with their weights sorted from heaviest to lightest in numerical order. I want to add further players and have the list reflect their standing each time it changes i.e. Col 1 Player ID, Col2 FirstName, Col 2 SecondName, Col 3 Mass:90 Kgs Col 4 Position In group: 1

A new player registers and is 95Kg.....he becomes #1 and the rest go down etc. Can this be done?

 

[pbaldy]

Think of the table as a bucket; you just throw data into it. You give it order when you draw it out via query, form or report.

 

[rolypoly]

The bigger picture is that I want to create a database that updates in real time. A player/coach inputs testing data and he finds out exactly where he stands within a global scenario.

i.e. Speed Test Result is 4.5 secs. He inputs it the data, which is auto sorted, and he sees that he is 1st in his group but only 31st in the global dynamic etc.

 

[pbaldy]

Doesn't change my answer; the form/report he is viewing would order the data accordingly.

 

[rolypoly]

rolypoly,
Think about it this way. A list has only a single physical order but there could be multiple logical orders for the same data depending on what you need to do. Your current concern is standing which is based on weight so you want the list sorted by weight. But, if you wanted to print a telephone list, you would want the list sorted by either first name/last name or last name/first name. It wouldn't make any sense to sort such a list by weight. So, each time you define an output (people shouldn't be opening tables directly) such as a form or report, you define a sort order for the selected data.

Hi Pat. I am new to MS Access as you can probably see. Could you give me some pointers on how to do that please.

 

[kipcliff]

You create a query based on your table, and add the fields you wish to work with. Then you specify a sort order for the weight field (ascending, light to heavy; descending, heavy to light).

Next, you create a form based on said query. (You can also specify sorting criteria in the form, if you wish.)