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