Fair point!!


>John, wouldn't that just give an exact copy of the table, but with an extra field, "REC"?
>
>>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