Can you append an auto number field to a query?

[shauns1]

Hi

Im would like to know if its possible to create an auto number field to a query so that no matter what your query returns, you'll always have a column starting at 1 and incrementing up for each record.

Example Query:

Select Top 10 TeamScore
From tblTeams
Order By TeamScore

How would I add a new column that started at 1 and ended in 10?

Many thanks

Shaun

 

[PHV]

Do Advanced Search in this forum for rank or ranking.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886