I'm having a bit of mental block here. I'm sure i've done this in Access before (altough i may be confusing myself with PL/SQL).

I have a query that returns
NAME
SCORE

in descending SCORE order into a Form/Report.

What i want is an auto generating incrementing field that gives me a position for each returned row (number of rows may vary, so needs to be dynamic) starting at 1 for the first row.

Thanks in advance.