ADDING A count +1

[sal21]

I have sql="select aaa from table"
this return

AAA
BBB
CCC
DDD

I need

AAA 1
BBB 2
CCC 3
DDD 4
... .

[HansV]

If the values of the aaa field are unique, you can use

sql = "SELECT aaa, (SELECT Count(*) FROM Table AS T WHERE T.aaa <= Table.aaa) AS Seq FROM Table"

[burrina]

What happens when you get to Z ?

[HansV]

I don't think Sal meant those values literally.

[sal21]

If the values of the aaa field are unique, you can use

sql = "SELECT aaa, (SELECT Count(*) FROM Table AS T WHERE T.aaa <= Table.aaa) AS Seq FROM Table"