Sequentially numbering the records in a query

[andrefrancis]

I need to add a column to a sorted query which effectively numbers from 1 to N. It is intended as a ranking field for later statistical analysis.

I can do this manually by saving the query as a table, then introducing a new autonumber field.

However, I need to do this automatically, as this is just one query out of many in a large and complex setup. Is it possible to add an autonumber field to a query?

Can anyone help?

 

[Meltdown]

This article form MS will give you what you want, it can be used in a query

http://support.microsoft.com/default.aspx?scid=kb;en-us;210340&Product=acc

 

[andrefrancis]

Thanks Meltdown ... I had seen this one, but I was hoping for something slightly simpler.

I also found this one ... which IS slightly simpler:

http://support.microsoft.com/?kbid=208946