>Yes, but you don't select the recno() (ie recno() is not selected as a new column). This is why I said you need to select again in order to get it as a column (this was the goal, right?)

True, but why do you need a column in the SQL that resembles the natural record order?! Just use Recno() after the fact.