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.