Adding a autonumber to a query

[royalcheese]

Hi all

I have this query

SELECT a.MEMBER_KEY, a.CONTS, a.DST, a.DEND
FROM CH AS a
ORDER BY a.MEMBER_KEY, a.DST;

I want to add a autonumber to it in the query stage , is this possible ?

Thanks in advance

C

 

[mp9]

If you mean you want to sequentialy number the rows your query returns, rather than add an autonumber which is a table field of a specific type, take a look at

http://www22.brinkster.com/accessory/forum/topic.asp?TOPIC_ID=4

for one possible solution.