Re: Please Help... (Grouping and Ranking)

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

OfficeDev18 wrote:
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..


--
- thx -

Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Ranking Records in a Select Query
    ... When you actually display the ... records getting the position in the recordset / rank is easy. ... > 1) Displaying a ranking next to each entry (this is a top sellers ... >>> I'm running Access 2002. ...
    (microsoft.public.access.queries)
  • Re: HK - Honor
    ... it does still count in a few places - e.g. the highest ranked player ... will be auto-assigned battleground-leader when they join.) ... and can choose to have this rank displayed in front of your name. ... you can choose to display it. ...
    (alt.games.warcraft)
  • Re: Pictures in Forms associated with specific IDs
    ... The way I have it set up is to have one main table with the basic scout ... number (ID number for respective patrol, rank and position). ... that to display so that as I cycle through each boy, ...
    (microsoft.public.access.forms)
  • Re: Move ranking with Crafty
    ... >> display the N best line). ... >>> I'd like to be able to use Crafty to rank and score all the possible moves ... > The reason I'd like to do this is that I'd like to know, ...
    (rec.games.chess.computer)