Function to Output Line Numbers in a Query

[Solar.Paul]

Is there a built in function which can be used to create line numbers in a query?

I've written a query to calculate year to date (YTD) points for yachts in a series of races and sorted it in descending order - so yacht 1 is coming first, yacht 2 is coming second etc. I'm looking for a way to add sequential numbering (starting at one and increasing by one for each line) into the query to represent their YTD places. Can someone help please? Or this this something that should be left to the report which uses the query?

Thanks in advance
Solar Paul

 

[bob fitz]

The following link may help: http://allenbrowne.com/ranking.html