Please Help... (Grouping and Ranking)

  • Thread starter Thread starter marco_pb via AccessMonster.com
  • Start date Start date
M

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..
 
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
 
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.
Click to expand...
[quoted text clipped - 3 lines]
thank you in advance..
Click to expand...
Click to expand...
 
Back
Top