How to rank data result

[hassaan]

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]

 

[lanato]

i think you can creat and run a update query just like:
UPDATE

SET

.Rank = DCount("*","Table","Point<=" & [Point]);