How to rank data result

hassaan

[HassaaN]
Local time
Today, 17:07
Joined
Jul 7, 2005
Messages
14
I have a table which has got the following fields:
Name and
Points

I want to create a third fieldw with the name of rank which should give automatic results of rank that is the one with the maximum points should have '1' written in his rank column. Similarly, all rank fields should be filled accordingly.
I used the help, it said i should apply the syntax.
I do not know how and where to apply that syntax
Your help is appreciated
[HassaaN]
 
i think you can creat and run a update query just like:
UPDATE
SET
.Rank = DCount("*","Table","Point<=" & [Point]);
 

Users who are viewing this thread

Back
Top Bottom