>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
Using recno() in SQL statements is a risky business. If there's more than one table in your FROM clause, the results are unpredictable. If you need records to appear in the order in which they were created, then it's best to have a field that stores the datetime() of the creation, and order by that.