Rank Column in Query

[Haynesey]

Hi,

I am trying to add a column into a query to rank items in that query.

For example, I want this table:

Name Score
Lee 10
Simon 8
Steve 8
Mike 6

to read:

Name Score Rank
Lee 10 1
Simon 8 2
Steve 8 2
Mike 6 4

I have read the Microsoft help but everytime I try and change the alias name of the query within a query, Access automatically says it is closing??

Any ideas

Many thanks in advance

Lee

 

[gemma-the-husky]

i think you will only get this by processing the recordset manually. You will probably need a rank field in the "name" table to store the number