How about this.

sele *,recno() as rec from table order by rec

>Does anyone know the correct syntax to create a SQL VIEW and order it in record # order ? I tried to add "order by recno()" to the end of my create sql view definition but it returned an error SQL: Column ' ' is not found.
>
>Thanks For Your Help !
>
>Stephen J. Hunt