Please Help... (Grouping and Ranking)

[marco_pb via AccessMonster.com]

I am noob in using ms access 2003, i want to ask for helps.
I have a form where it displays records of classes and scores information.
I wonder how I can sort it so then the top most record is the best score, and
got rank 1 and so on..
please help me..

thank you in advance..

 

[Guest]

Use the Orderby property of your form to order the data by score.

 

[OfficeDev18 via AccessMonster.com]

Marco,

Don't go through a loop trying to sort it in the form. In the form's record
source property, build a query based on your table. Click on the 'star' to
display all the fields, and add into the grid all fields you want sorted,
identify the sort direction, and clear the "Display" box, as they are already
displayed because of the 'star'.

Hope this helps,

Sam

 

[marco_pb via AccessMonster.com]

thanks to all, but the problem is I want the rank is written automatically.
users only input the scores and when it is previewed, i want the rank is
provided automatically for the users..
I dont know how to do it, but i hope it is possible.
thank you in advance for your helps.

best regards,

marco

Marco,

Don't go through a loop trying to sort it in the form. In the form's record
source property, build a query based on your table. Click on the 'star' to
display all the fields, and add into the grid all fields you want sorted,
identify the sort direction, and clear the "Display" box, as they are already
displayed because of the 'star'.

Hope this helps,

Sam

I am noob in using ms access 2003, i want to ask for helps.
I have a form where it displays records of classes and scores information.

[quoted text clipped - 3 lines]

thank you in advance..